![]() |
Rotating the data in a worksheet
I am fairly limited on knowledge for excel so any help would be appreciated.
I am importing data from another program into excel. I need to have the data in cells listed in each row converted to data in columns... Please help. |
Rotating the data in a worksheet
so, you want to transpose the data?
Copy the set, go to a blank spot, Edit/Paste Special and check the transpose box. "Carol" wrote: I am fairly limited on knowledge for excel so any help would be appreciated. I am importing data from another program into excel. I need to have the data in cells listed in each row converted to data in columns... Please help. |
Rotating the data in a worksheet
Depending upon the layout you may be able to do a simple copypaste
specialtranspose. See help for more. Or post more details on your layout. Gord Dibben MS Excel MVP On Fri, 30 Oct 2009 10:30:16 -0700, Carol wrote: I am fairly limited on knowledge for excel so any help would be appreciated. I am importing data from another program into excel. I need to have the data in cells listed in each row converted to data in columns... Please help. |
All times are GMT +1. The time now is 06:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com