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 ...
In this example i've copied range B1:F7 and then selected cell B20. Then right click with the mouse and paste options -> transpose.