I need an easiest way to do the follwoing. All the data in column A have each tag in column b. doing manually takes lo of time. column a have 1000 data and b have 200. please help
Sample attached
Coloumn A have Name lets say, John, Smith, Peter, Wang, Lee and coloumn B have JAN, FEB, MAR, APR, MAY
I need John-JAN, Smith-JAN, Peter-JAN, Wang-JAN, Lee-JAN below that John-FEB, Smith-FEB, Peter-FEB, Wang-FEB, Lee-FEB likewise. John in Column A and JAN in column B.