Forum Discussion
Transposing multiple rows to columns
Hi, I have an Excel list with a few hundred rows that I want to Transpose to a few columns. I can copy / paste and transpose one row, or write a formula for a single row. How would I transpond all ...
=INDEX($B$1:$F$7,COLUMN(A:A),ROW(1:1))You can try the above formula if you prefer this solution. I've entered the formula in cell B10 and copied across range B10:H14.