ExcelBanter - Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel (https://www.excelbanter.com/excel-discussion-misc-queries/178426-excel.html)

PhxlatinoboiÂ®

Excel

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

Gord Dibben

Excel

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?

All times are GMT +1. The time now is 10:07 AM.