KevNewton29
New Member
- Joined
- Jun 23, 2004
- Messages
- 9
I have a spreadsheet with 15,130 entries which relate to clients and their fund holdings. Quite a lot of the clients have different fund holdings in the same policy and are shown as a seperate row on the sheet.
Is there a way consolidating the rows thta have the same plan numbers and putting the entries on the fund holding column as seperate columns for each holding
i.e I have 4 rows that have plan number 1234 in funds Fund A (row 1), Fund B (row 2), Fund C (row 3) and Fund D (row 4) and all I require is one row with the columns
Plan number, Fund A, Fund B, Fund C, Fund D
Help!
Is there a way consolidating the rows thta have the same plan numbers and putting the entries on the fund holding column as seperate columns for each holding
i.e I have 4 rows that have plan number 1234 in funds Fund A (row 1), Fund B (row 2), Fund C (row 3) and Fund D (row 4) and all I require is one row with the columns
Plan number, Fund A, Fund B, Fund C, Fund D
Help!