|
|
#2
06-20-2014, 11:15 AM
|
|||
|
|||
You will want to export the spreadsheet to an Excel workbook and create a pivot table, then place an empty cell above each company name, then use a macro to take all of the data below each individual company name and transpose it into columns to the right of the data. I will attach the macro you will need to use as a text file.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 mail merge in excel to send pdf forms
|
heyullama | Excel | 7 | 12-01-2013 03:32 PM |
| Mail Merge Many URLs in one email by common email address | instantaphex | Mail Merge | 3 | 04-29-2013 05:46 PM |
| Mail Merge to email, changing images on email layout | ginelli | Mail Merge | 18 | 02-23-2013 09:47 AM |
|
Mail Merge with Booklets is Merging all documents into One stapled Booklet
|
15Degrees | Mail Merge | 1 | 01-31-2013 02:06 AM |
| Send e-mail message in Finish & Merge | CDTom | Mail Merge | 1 | 08-24-2012 12:52 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode