Sample of Contract information - "Aggregate".
1. "List Info I have (4 Columns)"
2. "Aggregated Info I want (4 Columns)"
Each CONTRACT_NO is the main field here, some CONTRACT_NO's have either 1 or 2 Rows of Contract data, that I'd like to aggregate/summarise.
Basically in Excel (not using Power Query), I want to use the 10 rows of data (from Tab 1), so that it is aggregated down to the 6 rows of data (in Tab 2).
Thanks.
1. "List Info I have (4 Columns)"
2. "Aggregated Info I want (4 Columns)"
1. "List Info I have (4 Columns)"
2. "Aggregated Info I want (4 Columns)"
Each CONTRACT_NO is the main field here, some CONTRACT_NO's have either 1 or 2 Rows of Contract data, that I'd like to aggregate/summarise.
Basically in Excel (not using Power Query), I want to use the 10 rows of data (from Tab 1), so that it is aggregated down to the 6 rows of data (in Tab 2).
Thanks.
1. "List Info I have (4 Columns)"
PROD_CODE | CONTRACT_NO | GROSS PREMIUM | NET PREMIUM |
10P3A | 15196000 | 2432.00 | 2372.68 |
10P3A | 15196000 | 3648.00 | 3648.00 |
10P3A | 15205210 | 1632.00 | 1592.50 |
10P3A | 15205210 | 2448.00 | 2479.50 |
REB5S | 0276537657657 | 1152.35 | 1095.55 |
45P3A | 16729380 | 2549.50 | 2162.17 |
45P3A | 16729380 | 3488.00 | 3425.50 |
REW5B | 08765421087657 | 1844.50 | 1834.50 |
REW5B | 08765421087657 | 2108.00 | 2009.35 |
WEV1P | 01113812003792 | 892.40 | 881.72 |
2. "Aggregated Info I want (4 Columns)"
PROD_CODE | CONTRACT_NO | GROSS PREMIUM | NET PREMIUM |
10P3A | 15196000 | 6080.68 | 5527.22 |
10P3A | 15205210 | 4080.57 | 4072.00 |
REB5S | 0276537657657 | 1152.35 | 1095.55 |
45P3A | 16729380 | 6037.50 | 5587.67 |
REW5B | 08765421087657 | 3952.50 | 3843.85 |
WEV1P | 01113812003792 | 892.40 | 881.72 |