MS-Access to Excel - Columns vs. Rows

[Krazy Kasper]

I have an MS-Access (2003) report, containing the usual data (customer name, address, etc., along with the products they've ordered) that I export to Excel (where I clean up some formatting problems). I then mail-merge the Excel data into an MS-Word document for mailing to customers.

My problem is that the product numbers export into separate Rows and I cannot pull them into the mail-merge. Is there a way to export them into Excel so they appear in separate columns? Then I could assign them separate column names and pull them into the MS-Word (mail-merge) doc.

Any help is much appreciated.

Krazy (Bill) Kasper

[Kenneth Hobson]

You can use WorkSheetFunction.Transpose to do it probably. You can attach an example xls if you like.