How to create table with vertical headers? (or transpose)

[jk-tagbangers]

I'd like to transpose row and column before exporting, like this article.
https://support.microsoft.com/en-us/office/transpose-data-from-rows-to-columns-or-vice-versa-in-excel-for-mac-9c16dd55-ed1a-4aa2-8b74-b1b9211e2ede

Or I'd like to create a table with a vertical header, any ideas on how to do that?