Learn how to Transpose Row to Column in Excel. Transpose converts horizontal row data sheets into vertical column style sheets and back.

However, by embedding the SEQUENCE function within the TRANSPOSE function, you can force Excel to fill the numbers down the rows, and then across the columns.

Q: To make an Excel table fit better on a page when I print it, I frequently have to transpose it—that is, move all the data from, say, rows 1, 2 ...