I am trying to accomplish something that perhaps is simple but I can’t see it. I have several rows of a “child product” that need to roll up into a “main product”, just one row. I dont know to group the child rows into the main one and get the correct name.

Example I have this:

| Product Code | Product Name | Package Code | RowType | Price | Usage | REvenue | VoucherFaveValue |
| GA-ADT |uss-ga-adult | ADUMR-SGR | main | 10 | 2 | 20 | 0
| mvCH5 |meal voucher | ADUMR-SGR | voucher| 0 | 0 | 0 | 5
| rvCH5 |retail voucher| ADUMR-SGR | voucher| 0 | 0 | 0 | 5
| **GA-chd |uss-ga-child | CHUMR | main **| 7 | 2 | 14 | 0
| mvCH5 |meal voucher | CHUMR | voucher| 0 | 0 | 0 | 5
| rvCH5 |retailvoucher | CHUMR | voucher| 0 | 0 | 0 | 5

I need to get this

| Product Code | Product Name | Package Code | RowType | Price | Usage | REvenue | VoucherTotalValue |
| GA-ADT |uss-ga-adult | ADUMR-SGR | main | 10 | 2 | 20 | 10
| **GA-chd |uss-ga-child | CHUMR | main **| 7 | 2 | 14 | 10