date in column.. need to put in a single row

[mithu]

I have a spreadsheet that has the date in months in the columns.

the headers are basically.

company ID | Jan | Feb| March| April | May | June |......


each months rows contain the revenue for that month for the respective
company id.. can i change it so the all the months are in one row?

so bascially have

Company ID | Month | revenue|

is there an easy way to do this? I also need all data to transpose
correctly.

 

[Guest]

hi,
copy the data you wish to transpose.
select a place to paste it.
on the menu bar....edit>pastespecial>check tranpose(near the bottom)
click ok.
yeah. that simple.
regards
FSt1