Ask a new question

Mail Merge - Switch Column Headers to Rows

I have a Word document with fields throughout the document.  Those fields are reapeated information.  The data form, which is in Excel, has headers and the information is filled in below the column headers.  Is there a way to have the Word document read the information from left to right instead?

Currently:

Date Lessee Name Lessee Name   (Short) Prior Lessee Lessor Name Owner Aircraft Make Aircraft Model
 8/25/14  United Airlines  United  American Airlines  Investor Camp  Junk Yrds  Airbus  A330-200

Preferred:

Date  8/25/14
Lessee Name  United Airlines
Lessee Name   (Short)  United
Prior Lessee  American Airlines
Lessor Name  Investor Camp
Owner  Junk Yards, Inc.
Aircraft Make  Airbus
Aircraft Model  A330-200


Word won't do the transposition of column headers from the data source to row names for you - you have to type that part for yourself. The rest is just a matter of inserting the relevant mergefields in the right-hand column then running the mailmerge. If you want to replicate the data, you can either bookmark and cross-reference the mergefields or insert more copies of the same mergefields.
Cheers
Paul Edstein
(Fmr MS MVP - Word)

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated April 18, 2024 Views 1,261 Applies to: