Turn 2 columns into rows, but keep 1st column

[nobrain82]

Hi,
So i have this problem...
Example in 2 columns bellow

Problem:

A | 1,2,3,4
B | 5,6

Result:
A | 1
A | 2
A | 3
A | 4
B | 5
B | 6

Any suggestions how to obtain the result?

[rcm]

Please Login or Register  to view this content.

[balajim]

if you have lesser rows use copy and paste as transpose values , to many rows go with macro

[nobrain82]

Thanks for fast reply. Is not working

[nobrain82]

there are 14k rows with 20-30 records separated by "," in second column

[rcm]

I thought that each entry was in a separate cell. I will repost it

[rcm]

Now give it a try

[nobrain82]

@rcm - you have a beer from me!

[rcm]

you are most welcome. mark the post as solved!!!