G Guest Oct 29, 2007 #1 I would like to transpose Column A to Column B....how do I do that in Office 2003?
G Guest Oct 29, 2007 #2 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.
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.
S Steve Oct 29, 2007 #3 I would like to transpose Column A to Column B....how do I do that in Office 2003? Click to expand... Right Click in Column B, Paste Special, Transpose Steve
I would like to transpose Column A to Column B....how do I do that in Office 2003? Click to expand... Right Click in Column B, Paste Special, Transpose Steve
P Peo Sjoblom Oct 29, 2007 #4 Select column B, right click header and select cut, then select A header and right click and select insert cut cells. -- Regards, 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 Oct 29, 2007 #5 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
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