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.