flip a worksheet across a diagonal
Occasionally I set up a worksheet with, for example 10 rows, and I keep on adding new columns of data to the right, until I have for example 100 columns. By that time, I might wish that I had started off with 10 columns, and added new data by adding new rows at the bottom of the sheet. Unfortunately, there seems to be no way to change the orientation of an existing worksheet automatically, with one easy command. Or at least I can't find a way to do this.
I would like to be able to do the following:
Select part of the worksheet, say A1 to CV10.
Specify the "flip line", say A1 to J10
The result is:
Cells A1, B2, C3, D4, etc. do not change.
Cells A2 and B1 swap their contents, including any formulas.
Cells A3 and C1 swap their contents, including any formulas.
Cells A4 and D1 swap, and cells B3 and C2 swap
The final result is that the data and formulas that were in the range A1 to CV10 are now in the range A1 to J100.