Hi,
I'm relatively new to excel and i'm not sure if my question belongs here or in programming so i apologize ahead of time if i am wrong. i have contact information as follows:

Name
address
city, state zip

All data entered in column A and sometimes 'address' can be 2 or 3 more lines before the City state line. All info is text. my question is how do i convert the vertical mailing style contact info into a more manageable format as follows:

Name Address City StateZIP State
(repeat state for organization)

With Name in A, Address in B and so on. My ultimate purpose is to better organize this data and to put it into mailing label form for Word to print.

Thank you for taking the time to read my post, it is much appreciated.

-AY