I need some help converting an exported address file so i can align the columns properly and perform a mail merge in Word.
The problem iI am having is Excel has in Row A the following
A
1)company name
2)address
3)company name
4)address
5)company name
6)address
how do I get ever second line moved to a column so everything lines up and I have two columns of name and address. I have several thousand records to fix up and make a mail merge document for a letter
thanks
Bookmarks