I think you are wanting a Cross Tab query. You have three options here.
1. Easy Option:
You can export the information to excel and then copy the information, open a blank spreadsheet, choose "Paste Special" and click the transpose button and it converts the data.
2. Other Option:
Build A report in Access with all your column headings going down the left side:
3. Click, New Query, Choose "Crosstab Query". This only allows you to have three columns.
Keep in mind for options 1 & 2 you have a maximum of 256 columns so if you have more rows of data than 256 then you are going to get an error.
I hope this helps.