![]() |
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? |
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