Hi,

I have a data in rows and I want to convert it to vertical columns while keeping (and duplicatin) the Id columns in order to import it to my DB later.

Please see an example:
this is how I get the data:
id first last City zipCode
1 Dan Mano Ney-york 12345
2 Deby Roger Chicago
3 Ben Stiller Boston 4555

This is how I eventually want it to be:
Id ItemValue
1 dan
1 Mano
1 New-York
1 12345
2 Deby
2 Roger
2 Chicago
3 Ben
3 Stiller
3 Boston
3 4555

As you can see if there are blank cells I ignore them.

Is there a solution to my problem?

thanks in advance

Omer