How to convert data from Columns to rows

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
 

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
Select method failed - Error 400 2
15 minute data to daily data 1
Help!! find two number recurring numbers in row?? 1
Time Calculations Help 5
Macro to select rows based on dates 11
Sorting problem : "The sort reference is not valid..........." 3
Macro problems in XP 1

Top