how to convert p&l data from month report by row to colume ?

[paulyeo11]

Hi All,

I have a P&L report , the date is in row , and colume 1 is all the variable .

date..... jan .... feb ....
sales....123.....432....
exp.......23......23....
profit.....100....400...

I like to convert it to following :-

date...sales...exp...profit.
jan.....123......23.....100
feb-----432......23.....400

Hope some one can share with me how to use code or formula to do this.

paul yeo

 

[Datsmart]

You can transpose the data like this:

Select your range, Ctrl-C to copy.
Right click the cell you want to copy it to, choose Paste Special.
Check Transpose.
(Note: You can not Transpose to a cell with-in the source range.)

 

[paulyeo11]

Hi Sir , thank you very much for yr reply. i will try it out.

paul