I have an address list in excel that I want to do a mail merge with. My
list, however, is not set up so that I have name in column 1, address in
column 2, and city state zip in column 3... It's set up like the following:

Row 1:Name
Row 2: Address
Row 3: City, State Zip

Is there an easy way to do a mass reformat to move the row 2 & 3 fields so
that they are column fields instead? I have about 200 addresses so manual
manipulation would be very inefficient.