MS Excel 2010 - Name- Address-City, State and Zip in 3 separate rows - want to change to columns

[lgrande]

Reaching out for help after many attempts. I dont think text to columns will work in this situation, but not sure

A2 = Name
A3 = Street Adress
A4 = City, State and Zip

A5 =Then a blank row

A6 = Name
A7 = Street Adress
A8 = City, State and Zip

And so on..


I need to make labels and this format is not going to work.

Unfortunately I have many people in column A, so I am not sure if we can get this.

I would like

Name in Column A
Street address in column B
City State and Zip in Column C

 

[mfexcel]

Since the structure of your data source is stable, you may consider a formula approach by using Index. As such, you may get every 1st, 5th, 9th, etc... cell under Name; 2nd, 6th, 10th cell under Street and so on...

Reaching out for help after many attempts. I dont think text to columns will work in this situation, but not sure

A2 = Name
A3 = Street Adress
A4 = City, State and Zip

A5 =Then a blank row

A6 = Name
A7 = Street Adress
A8 = City, State and Zip

And so on..


I need to make labels and this format is not going to work.

Unfortunately I have many people in column A, so I am not sure if we can get this.

I would like

Name in Column A
Street address in column B
City State and Zip in Column C