Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting rows or columns | Tables | |||
Data Merge - Excel Records to Word Table Columns NOT Rows | Mailmerge | |||
Hiding Rows and Columns | Tables | |||
'Tables'- 2 columns,4 rows. Can you merge one column into 3 rows? | Tables | |||
convert columns into rows | Tables |