I have big excel document with content isn't for calculating. It's used to display a structure.

I have headings in the sheet going left to right with content in every column beneth each heading. The content of the cells is often very long.

I would now like to reverse the axis so the headings with colums go from top to bottom instead of left to right. I want the heading to end up in the first column and each column to be a row after each heading.

Is this possible??

I know I can wrap the lines, but I'm not interested in that.