Hi,
Can you please help on how to bring comma separated values present in a column into cells in next row.
Comma separated columns are present in Column B. Column A is not comma separated. Please look into the sample input and expected output.
I have around 10,000 records like this. Please suggest on the solution.
E.g. (Sample Input)
-------------------
Column A Column B
John 1999,2002,2003
James 2003,2002,2001,2004,2005
Joe 1999,2001
Expected output
-----------------
Column A Column B
John 1999
2002
2003
James 2003
2002
2001
2004
2005
Joe 1999
2001
Regards,
Pal.
Bookmarks