Data in columns i.o. rows

[Lupe]

Hi,
I have set up a mail merge document which reads its data from Excel rows.
As there is much data needed for each record I have changed the column
widths so that more columns can appear at the same time on the screen. The
students asked if it is possible to put the data in columns i.o. rows, so the
headers will be in column 1 and the date in column 2. Is this possible?
Example:
1st column 2nd column
Name Lupe
Address 326th NW Street
Birthdate 14 August 1962
etc. etc.

 

[Dawn Crosier, Word MVP]

It's possible for data entry purposes, but not for merging purposes.

In Excel, select your range of data.
I would select Sheet 2 and select Paste off the Menu.
Select Paste Special and select Transform.
The data will twist itself from columns to Rows, but Word will still
need it in Columns to perform the merge.

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.

Hi,
I have set up a mail merge document which reads its data from Excel rows.
As there is much data needed for each record I have changed the column
widths so that more columns can appear at the same time on the screen. The
students asked if it is possible to put the data in columns i.o. rows, so the
headers will be in column 1 and the date in column 2. Is this possible?
Example:
1st column 2nd column
Name Lupe
Address 326th NW Street
Birthdate 14 August 1962
etc. etc.

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.32/1033 - Release Date: 9/27/2007 11:06 AM

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.32/1033 - Release Date:
9/27/2007 11:06 AM

 

[Lupe]

Hi Dawn,
Thanks for your reply. I know about the Paste Special --> Transpose (was it
a typing error or is it called Transform in newer versions vs 2000?). I
wanted this for merging purposes, but the students have to do with the
columns, it is making their life easier anyway.
Regards, Lupe Antonisia

 

[Dawn Crosier, Word MVP]

Lupe -

You are correct - Transpose is the proper term.

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.

Hi Dawn,
Thanks for your reply. I know about the Paste Special --> Transpose (was it
a typing error or is it called Transform in newer versions vs 2000?). I
wanted this for merging purposes, but the students have to do with the
columns, it is making their life easier anyway.
Regards, Lupe Antonisia

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.32/1033 - Release Date:
9/27/2007 11:06 AM