Hi Experts,

Please refer to the attached sheet. The data contains three columns Col 1, Col 2 and Col 3. Ignore Col 1.
Col 2 and Col 3 share a parent-child many-many relation as an example aa-a, aa-b, bb-a and so forth. The intent is to consolidate unique combinations of parent-child on a separate sheet with the parent displayed as a rolled-up row. Further, a third column which can be entered by the user is also present that has allocations (essentially percentages) and the sum of the children should roll up into the parent row with a validation of a maximum of 100%.

Request you to help me with this.

Thanks in advance