Help

Compile multiple entries into a single entry

1391 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jon_Richings
6 - Interface Innovator
6 - Interface Innovator

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:

image.png

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.

image.png

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?

0 Replies 0