I have a list of names and addresses that are in rows. Does anyone know of
way to move the address and city state zip to columns so that I can do a mail
merge and print labels. I know I could cut & paste but that would take a
long time.

Example
Name1
Address 1
City state zip1
Name2
Address 2
City state zip2

if name1 is in a2
I would like for address 1 to go to B2 and city state to go to c2