Hi, I have a spreadsheet that has information in 1 column but in different rows. For example:
Column C
Row 2 Name
Row 3 address
Row 4 city ST zip
Row 5 Name
Row 6 address
Row 7 city st zip

and so on

Is there anyway to move the address and city st zip to seperate columns with the name of the person on the same row?

Thank you