CopyPaste SpecialTranspose.

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

On Sat, 1 Mar 2008 11:19:01 -0800, Phxlatinoboi®
wrote:

How do I invert numbers that are all in a row and change them to a column?