I have these Companies list that I want to copy from rows into a column but only in a blink of an eye.
- Select all the rows that you want to create columns.
- Right, Click on any column like B1 or C1.
- From the Paste options select Transpose.
- This will create Columns with each Row that you selected.
Here is the result.
to Turn your rows into Columns is to use the =transpose Formula.
=transpose(array) select the arrays ( no of rows ) that you want to turn into Columns.
Press Alt+ H+ V+ S+V+E press Enter Button , that’s it 😉