How to convert data from Columns to rows

  • Thread starter Thread starter ajmister
  • Start date Start date
A

ajmister

Hi
I have a spreadsheet that has data in the following format

DATATYPE 9/23/1998 9/24/1998 9/25/1998 9/28/1998
price 45.56 44.38 44.25 44.63
code 1539854 1539854 1539854 1539854

And would like to convert to the following format.


Date Price Code
9/23/1998 45.56 1539854
9/24/1998 44.38 1539854
9/25/1998 44.25 1539854
9/28/1998 44.63 1539854

Is it possible in Excel?


Ajay
 
Copy the data. Paste using the menu Edit | Paste Special | Transpose.

HTH,
Merjet
 
You must log in or register to reply here.

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

Comparing dates 1
Need subtotals 12
multiple vlookup; index/match 2
Change delimiter position based off of Last Name 3
Macro problems in XP 1
converting pivot table data to summary data 1
Quick Date entry revisited 7
can this be done faster? 7

Back
Top