Transpose sheet

From Sterbal's Sundry Studies

To transpose Sheet1 on an excel workbook use the following:

A B C D D F G H I
1 Headers Data Header Row Data Row 3
2 =INDIRECT(G2,FALSE) =INDIRECT(H2,FALSE) ="sheet1!R1C"&(ROW()-1) ="sheet1!R"&$I$1&"C"&(ROW()-1)
Retrieved from "https://sterbalssundrystudies.miraheze.org/wiki/Transpose_sheet?oldid=4224"