K
kas
Hi. I have a sheet of data listing different clients and charge types,
something like this:
Ref Name Code Amount
101 Jones A1 10.00
101 Jones B1 1.25
103 Smith A1 15.00
103 Smith C1 2.75
And I need to split it, like this:
Ref Name A1 B1 C1
101 Jones 10.00 1.25 -
103 Smith 15.00 - 2.75
I can achieve this by sorting and using lookups, but the data is going to be
refreshed so I am looking for simple way to achieve this. Hope you can help.
Many thanks.
something like this:
Ref Name Code Amount
101 Jones A1 10.00
101 Jones B1 1.25
103 Smith A1 15.00
103 Smith C1 2.75
And I need to split it, like this:
Ref Name A1 B1 C1
101 Jones 10.00 1.25 -
103 Smith 15.00 - 2.75
I can achieve this by sorting and using lookups, but the data is going to be
refreshed so I am looking for simple way to achieve this. Hope you can help.
Many thanks.