I'm not sure if this is better posted here or in an Access board. I have
query in Access that I'd like to bring into Excel. There are only about a
dozen records, but each has roughly 750 fields (most are blank).

I actually WANT it transposed so that it is a dozen columns wide x 750 rows.
I'm familiar with the transpose function, but that won't work because it's
too many columns to get into Excel to begin with. I have it in a columnar
formatted report in Access now & it looks exactly like I want it, but when I
export it to Excel, it puts each record on a separate row.