Is there a way to rotate text and export to Excell macro/automated?

[Tumoz]

I forgot to add Column C data in Access Queries to each Excel file i exported out from Access.
This whole project took me 3 days manually, is there a way to automate it?

Question:
Can i somehow record macro to rotate text in Access Queries and export them into different Excel files?
I want to seperate prospects and leads to different excel file from each country.

Column A	Column B	Column C
Prospect	Swe	id
Lead	Swe	id
Prospect	Nor	id
Lead	Nor	id
Prospect	Rus	id
Lead	Rus	id

<tbody>
</tbody>