I've got a query I want to write to Excel. Except, I want to write each row of the query into a column of the spreadsheet (so the column heading become row headings). Any chance to get that to happen??

Don't know about a direct path, but what about exporting as is, and using the Transpose function in Excel?