ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Rotating the data in a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/247067-rotating-data-worksheet.html)

Carol

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.

Sean Timmons

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.


Gord Dibben

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