Quote:
Originally Posted by Mjpunj
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.
|
This is great. Now mail merging is a lot simpler! Thanks.
There is one slight prob i have now - when the macro transposes - the value of the date columns then becomes numerical. Is there a way I can retain the format of dd/mm/yyyy?