G
Guest
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
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