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
 
Back
Top