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