How do I invert numbers that are all in a row and change them to a column?
P Phxlatinoboi® Mar 1, 2008 #1 How do I invert numbers that are all in a row and change them to a column?
G Gord Dibben Mar 1, 2008 #2 Copy>Paste Special>Transpose. Note: you cannot paste within the original row. i.e. Copy A1:IV1 then select A2 and do the paste. Delete row 1 after the transpose. Gord Dibben MS Excel MVP
Copy>Paste Special>Transpose. Note: you cannot paste within the original row. i.e. Copy A1:IV1 then select A2 and do the paste. Delete row 1 after the transpose. Gord Dibben MS Excel MVP