Rows to Columns or Columns to Rows in a single click
There is need to have a single click swap of rows and columns which should change Rows to Columns or Columns to Rows in a single click. Please check this and implements as soon as possible with user friendly tag or option.
Virg Unger commented
I would like this myself. It would save me having to write a custom macro or vba code that would scan through one sheet, setting sheet 2 cells equal to sheet 1 cells, but inverting letters to a number (a=1, b=2, c=3, …) and numbers to a letter (1=a, 2=b, 3=c, …) and then after every cell has been set in sheet 2, copy the entire sheet 2 and paste it as a value.
Here's a formula to get that process started.
copy this formula to as many rows/columns and columns/rows to needed on a new sheet
do a find and replace of Sheet1 changing it to the name of the sheet you want to flip
next copy the entire new sheet of all of these formulas and paste as a value
next press 'F2' and 'enter' for each cell and then you have all the values of the original sheet
finally copy the entire new sheet of all of these new formulas and paste as a value
voila, rows and columns switched
Scott Nessa commented
I have been trying to figure out how to do this. Would love this option.