I have a report in Access that I need to export to Excel. The report is formatted correctly like this.
Customer Name Account1 Number, Charge
Account2 Number, Charge
Account3 Number, Charge,
and so on.
When the report or even the query its based on exports it looks like this.
Customer Name, Account 1 number, Charge, account 2 number, Charge, Account 3 number charge.
Is there any way to control the formatting of the export from Access or even in Excel?