Transposing columns

K

Kevin B

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.
 
P

Peo Sjoblom

Select column B, right click header and select cut, then select A header
and right click and select insert cut cells.

--


Regards,


Peo Sjoblom
 
G

Gord Dibben

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
 
Top