Template Help - List of unique items (not a ref)

[Grant_Stead]

I have a table of assets, In this table I create a concatenated text field I want to create a unique list of these, and post next to them an associated quantity.

Right now, I’m posting the entire table of assets to an xlsx template, and in another sheet of that template I’m using spreadsheet formulas to FILTER(UNIQUE()) and then SUMIF expressions to bring in the quantities.

I really need to get this list and associated quantities into a PDF output report. Anyone know how to do this?