Using named ranges in data merge documents

  • Thread starter Thread starter Nicole
  • Start date Start date
N

Nicole

Hello, everyone. Is there any way of using named ranges (in Excel) as
the merge fields in a (Word) data merge document? I mistakenly
formatted my data source with the field labels at left and the records
at top (in other words, with the whole table rotated 90 degrees), and
I've been trying to figure out a way to get the proper fields into the
data merge document. Alternately, a way of rotating the table in Excel
would work. (There's too much data to cut and paste into a new
format.) Any advanced users here who can help with this!

Thanks,
Nicole
 
Nicole,

Perhaps you can copy the entire table, then in another sheet, Paste
special - Transpose. You can then copy/paste the entire thing back to the
original location (after deleting the original. You can't do the transpose
to the same place as the original.
 
Back
Top