![]() |
#1
|
|||
|
|||
![]()
I would like to export from excel to word tables, but certain columns to become split in rows column.
I give here an excel (the database file) and a word (as a model of how I would like to export the data). From excel file, columns C and D should appear under same column but different rows in the word table. Is there a way (not manually, as I did it) to make this happen? Thank you! |
#2
|
||||
|
||||
![]()
How are you doing the 'export'? A simple copy/paste won't produce such a result.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]() Quote:
How to get the result I want? Is there a way? |
#4
|
||||
|
||||
![]()
Depending on the approach you want to take, it could be done via a mailmerge, a DATABASE field, or a macro.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
![]()
Ok. Take me as a noob. All I know, I learned on the internet. I know so little I could not understand mailmerge, database field, macro.
So, could you explain it? |
#6
|
||||
|
||||
![]()
Attached is a document showing the output generated via a DATABASE field. Simply save the document to the same folder as your 'Excel data base.xlsx' workbook. If you edit & save the Excel data, clicking in the DATABASE field and pressing F9 will refresh the Word table.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Tables from Excel to Word: Problems | Guillo | Word | 0 | 11-19-2014 01:42 AM |
![]() |
zachg18 | Word | 1 | 07-15-2013 11:10 PM |
![]() |
QuasidodoJr | Word | 1 | 04-24-2012 04:18 PM |
how to copy all ms word tables into excel | rehan129 | Word | 0 | 01-28-2012 10:17 AM |
![]() |
ripcurlksm | Word Tables | 2 | 09-09-2011 04:59 AM |