How-To Geek Forums Topic: Data merge in Word

How-To Geek Forums Topic: Data merge in Word http://www.howtogeek.com/forum/ How-To Geek Forums Topic: Data merge in Word en Fri, 09 Jan 2009 08:19:06 +0000 nekizalb on "Data merge in Word" http://www.howtogeek.com/forum/topic/data-merge-in-word#post-30581 Tue, 24 Jun 2008 06:38:34 +0000 nekizalb 30581@http://www.howtogeek.com/forum/ If I understand you correctly, you're trying to reverse your rows and columns. So 12 34 would become 13 24 If that is the case, then what you need to do is... Select the data Copy to clipboard select another area with enough room to copy the new data too (you need to copy first into excel, then you can copy the reveresed data into word.) Go Edit->Paste Special (03) or hit the down arrow on the Paste button and hit Paste Special (07) Check the 'Transpose' checkbox Hit OK Your data should paste with the rows and columns reversed. If you still need it in Word, then copy the new data, and merely paste it into Word. Or if you need it to be a linked object, you can follow the Paste Special dialog box to paste and a linked Microsoft Office Excel Worksheet Object. Hope I helped! gwh on "Data merge in Word" http://www.howtogeek.com/forum/topic/data-merge-in-word#post-29792 Fri, 20 Jun 2008 11:42:57 +0000 gwh 29792@http://www.howtogeek.com/forum/ Hi All, I have a table in Word with 4 rows and 4 columns. In Excel I have a 4 column spreadsheet and I want to merge the data form the spreadsheet into the Word document. I've set up a data merge in Word and have inserted the field codes that relate to the 4 columns in the Excel spreadsheet into the first 4 rows of the table in Word. I then copied these 4 field codes and pasted them into the other rows of the other 3 columns in the table. I was hoping that when I merged to a separate document that the first row in the spreadsheet would merge into the first column, the second row into the second column, the third into the third and the fourth into the fourth. Then I thought it would automatically create a new page and the rest of the spreadsheet rows would merge into the columns of the new pages. This didn't happen though. Instead it used 1 page for each row of the spreadsheet and just copied the values of the first column into the other 3 columns so there were 4 instances of each row of the spreadsheet on each page. Is it possible to have the data merged as described above instead of what's happening now? Thanks for any help.