Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-28-2018, 03:49 AM
eperdos eperdos is offline From excel to custom Word tables Windows 7 64bit From excel to custom Word tables Office 2010 64bit
Novice
From excel to custom Word tables
 
Join Date: May 2018
Posts: 3
eperdos is on a distinguished road
Default From excel to custom Word tables

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!
Attached Files
File Type: xlsx Excel data base.xlsx (8.1 KB, 9 views)
File Type: docx Word table final result.docx (14.0 KB, 9 views)
Reply With Quote
  #2  
Old 05-28-2018, 05:52 AM
macropod's Avatar
macropod macropod is offline From excel to custom Word tables Windows 7 64bit From excel to custom Word tables Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

How are you doing the 'export'? A simple copy/paste won't produce such a result.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-28-2018, 05:55 AM
eperdos eperdos is offline From excel to custom Word tables Windows 7 64bit From excel to custom Word tables Office 2010 64bit
Novice
From excel to custom Word tables
 
Join Date: May 2018
Posts: 3
eperdos is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
How are you doing the 'export'? A simple copy/paste won't produce such a result.
Yes. My bad. So:

How to get the result I want? Is there a way?
Reply With Quote
  #4  
Old 05-28-2018, 06:23 AM
macropod's Avatar
macropod macropod is offline From excel to custom Word tables Windows 7 64bit From excel to custom Word tables Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #5  
Old 05-28-2018, 06:48 AM
eperdos eperdos is offline From excel to custom Word tables Windows 7 64bit From excel to custom Word tables Office 2010 64bit
Novice
From excel to custom Word tables
 
Join Date: May 2018
Posts: 3
eperdos is on a distinguished road
Default

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?
Reply With Quote
  #6  
Old 05-28-2018, 04:05 PM
macropod's Avatar
macropod macropod is offline From excel to custom Word tables Windows 7 64bit From excel to custom Word tables Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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.
Attached Files
File Type: docx Word Database Output.docx (14.4 KB, 12 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tables from Excel to Word: Problems Guillo Word 0 11-19-2014 01:42 AM
From excel to custom Word tables Blury Excel Tables in Word zachg18 Word 1 07-15-2013 11:10 PM
From excel to custom Word tables Issues with Excel tables in Word 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
From excel to custom Word tables Excel Tables to MS Word ripcurlksm Word Tables 2 09-09-2011 04:59 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft