Compile multiple entries into a single entry


OK, the title isn’t very helpful, I can’t think of a better way to describe this:

I need to create a table that is really just the aggregation of another in a single entry.

I have a table that looks like this:

I want to create a new table where every entry (in the existing table) with the same Kit name is compiled into a single entry with the “Parts”, Part Name" and “How Many” columns are listed as multiline text, and the sums of all the other columns are listed as separate columns.

Where “Parts List” is a multi line showing all the entries from the previous table.

Ultimately I’d like then to be able to print each of those entries as a separate page with the multiline expanded.

Any ideas?