I have the following type of raw data:

Member No. Date Type Value
50772 28/02/2005 Unit A 480
50772 28/02/2005 Unit B 875
50772 02/03/2005 Unit A 109
66221 28/02/2005 Unit B 390
77344 28/02/2005 Unit A 133
77344 03/03/2005 Unit A 600
77344 03/03/2005 Unit B 82

I need to rearrange it so that 'A' and 'B' Unit Types appear in the same
row, where the Member no. and the Date are the same, otherwise, they remain
in seperate rows. The result should look as follows:

Member No. Date Unit A Unit B
50772 28/02/2005 480 875
50772 02/03/2005 109
66221 28/02/2005 390
77344 28/02/2005 133
77344 03/03/2005 600 82

Any suggestions as to the easiest way of doing this would be appreciated.