Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Lupe Lupe is offline
external usenet poster
 
Posts: 15
Default Data in columns i.o. rows

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.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dawn Crosier, Word MVP Dawn Crosier, Word MVP is offline
external usenet poster
 
Posts: 425
Default Data in columns i.o. rows

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.




"Lupe" wrote in message
news
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


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Lupe Lupe is offline
external usenet poster
 
Posts: 15
Default Data in columns i.o. rows

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" wrote:

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.




"Lupe" wrote in message
news
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



  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dawn Crosier, Word MVP Dawn Crosier, Word MVP is offline
external usenet poster
 
Posts: 425
Default Data in columns i.o. rows

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.




"Lupe" wrote in message
:

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


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting rows or columns Rufus Tables 2 July 28th 07 12:42 AM
Data Merge - Excel Records to Word Table Columns NOT Rows eagleshout Mailmerge 1 May 14th 07 07:54 AM
Hiding Rows and Columns ron10bees Tables 1 September 23rd 06 10:17 PM
'Tables'- 2 columns,4 rows. Can you merge one column into 3 rows? CalMac Captain Tables 1 May 19th 06 03:27 PM
convert columns into rows GreenEyedMedusa Tables 3 November 28th 05 08:50 PM


All times are GMT +1. The time now is 12:13 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"