ExcelBanter - How do I convert columns of data to rows in excel?

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do I convert columns of data to rows in excel? (https://www.excelbanter.com/new-users-excel/195149-how-do-i-convert-columns-data-rows-excel.html)

Glen in Pen

How do I convert columns of data to rows in excel?

I am trying to convert 1 column of data into a row. Is there a simple way to
do this?

StumpedAgain

How do I convert columns of data to rows in excel?

Copy/Cut your row and rightclick the destination. Choose "Paste Special" and
check the "Transpose" option. That should do it!
--
-SA

"Glen in Pen" wrote:

I am trying to convert 1 column of data into a row. Is there a simple way to
do this?

StumpedAgain

How do I convert columns of data to rows in excel?

I just tried the Cut/Paste Special... and it's not available. You can only
do this using the Copy function. Weird...
--
-SA

"StumpedAgain" wrote:

Copy/Cut your row and rightclick the destination. Choose "Paste Special" and
check the "Transpose" option. That should do it!
--
-SA

"Glen in Pen" wrote:

I am trying to convert 1 column of data into a row. Is there a simple way to
do this?

Glen in Pen[_2_]

How do I convert columns of data to rows in excel?

Sweet. Thanks!

"StumpedAgain" wrote:

Copy/Cut your row and rightclick the destination. Choose "Paste Special" and
check the "Transpose" option. That should do it!
--
-SA

"Glen in Pen" wrote:

I am trying to convert 1 column of data into a row. Is there a simple way to
do this?

All times are GMT +1. The time now is 02:08 AM.