Appending / Concatenating by Client Number
 

I currently have multiple rows per client in a worksheet and would like to
reduce it to ONE row per client. However, I would like to
capture the information from each of the rows when reducing to one row.

For example:
Client No |Account_No|Deposit |
75 1000 700
75 2000 200
62 4500 150
62 5000 500
62 5500 250

I would like it to be:
Client No|Accnt No_a|Accnt No_b|Accnt No_c|Deposit_a|Deposit_b|Deposit_c|
75 1000 2000 700
200
62 4500 5000 5500 150
500 250

Is there a way to do that?

Many thanks,
Dina