seprate data in rows to columns

[alansidman]

I think what you are looking for can be accomplished by normalizing your spreadsheet.

Normalizing a table with repeating fields -- DataWright Information Services