ExcelBanter - Flipping column and row headings

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Flipping column and row headings (https://www.excelbanter.com/excel-discussion-misc-queries/36331-flipping-column-row-headings.html)

seve

Flipping column and row headings

Hello,

I need to flip the column and row headings.

Is this possible?

Thanks,

Steve

aristotle

Steve,

I think you should use the transpose formula, you highlight say the column
area A2:A11 and type =TRANSPOSE(B1:B10) and finish with Ctrl+Shift+Enter.

Give it a whirl...

"seve" wrote:

Hello,

I need to flip the column and row headings.

Is this possible?

Thanks,

Steve

All times are GMT +1. The time now is 11:02 AM.