Rotating the data in a worksheet

C

Carol

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.
 
S

Sean Timmons

so, you want to transpose the data?

Copy the set, go to a blank spot, Edit/Paste Special and check the transpose
box.
 
G

Gord Dibben

Depending upon the layout you may be able to do a simple copy>paste
special>transpose.

See help for more.

Or post more details on your layout.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Copy data from unlocked cells 3
Getting Text data using the Data - Subtotal feature 1
Lookup Column Headings and Sum the Rows 3
Excel 2003 - Importing External Data - formatting problem? 2
VBA - retrieve data on last create named range from previous inserted named range 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel worksheet moved all data from multipl cells into one 1

Top