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.

transpose-selection excel 365

2nd method

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.

3rd method

Press Alt+ H+ V+ S+V+EĀ  press Enter Button , that’s it šŸ˜‰