Transposing columns

  • Thread starter Thread starter Guest
  • Start date Start date
Copy the column and then move the point to the cell where you want the data
to start in and click EDIT in the menu, select PASTE SPECIAL and place a
check in the TRANSPOSE check box. Click OK to complete.
 
Select column B, right click header and select cut, then select A header
and right click and select insert cut cells.

--


Regards,


Peo Sjoblom
 
One more.....

Select column B.

Slide cursor down to side of B1 and you will get a 4-headed arrow.

Hold SHIFT + click and move to left.


Gord Dibben MS Excel MVP
 
Back
Top