G
Guest
I have a database report which has been exported into Excel. I want to
rearrange the presentation of the data. Currently the data is presented as
follows:
COSTCENTRE1 ACCOUNT CODE 1 VALUE
COSTCENTRE1 ACCOUNT CODE 2 VALUE
COSTCENTRE1 ACCOUNT CODE 3 VALUE
COSTCENTRE2 ACCOUNT CODE 1 VALUE
COSTCENTRE2 ACCOUNT CODE 2 VALUE
COSTCENTRE3 ACCOUNT CODE 1 VALUE
COSTCENTRE3 ACCOUNT CODE 2 VALUE
COSTCENTRE3 ACCOUNT CODE 3 VALUE
Note: Each cost centre may have up to three account codes.
I would like to present the data like this:
ACCOUNT CODE 1 ACCOUNT CODE 2 ACCOUNT CODE 3
COSTCENTRE1 VALUE VALUE VALUE
COSTCENTRE2 VALUE VALUE
COSTCENTRE3 VALUE VALUE VALUE
How can this be done on Excel?
Thanks.
rearrange the presentation of the data. Currently the data is presented as
follows:
COSTCENTRE1 ACCOUNT CODE 1 VALUE
COSTCENTRE1 ACCOUNT CODE 2 VALUE
COSTCENTRE1 ACCOUNT CODE 3 VALUE
COSTCENTRE2 ACCOUNT CODE 1 VALUE
COSTCENTRE2 ACCOUNT CODE 2 VALUE
COSTCENTRE3 ACCOUNT CODE 1 VALUE
COSTCENTRE3 ACCOUNT CODE 2 VALUE
COSTCENTRE3 ACCOUNT CODE 3 VALUE
Note: Each cost centre may have up to three account codes.
I would like to present the data like this:
ACCOUNT CODE 1 ACCOUNT CODE 2 ACCOUNT CODE 3
COSTCENTRE1 VALUE VALUE VALUE
COSTCENTRE2 VALUE VALUE
COSTCENTRE3 VALUE VALUE VALUE
How can this be done on Excel?
Thanks.