ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I move data in prexisting rows to columns? (https://www.excelbanter.com/excel-worksheet-functions/99454-how-do-i-move-data-prexisting-rows-columns.html)

darryl

how do I move data in prexisting rows to columns?
 
I have ranges of data in rows. I want to arrange the data in columns. How do
I go about it?

Bondi

how do I move data in prexisting rows to columns?
 

darryl wrote:
I have ranges of data in rows. I want to arrange the data in columns. How do
I go about it?


Hi Darryl,

Maybe you can use the Transpose option under Paste Special.

Select your data - Edit - Copy.
Then select where you want your data and go to Edit - Paste Special
and tjeckmark Transpose and press OK.

Regards,
Bondi



All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com