@Jettek What exactly do you mean by "consolidate the list"? Do you want a list of unique items only, and perhaps sum/count how many of each there are in the list? If so, a pivot table could do that. Alternatively, is you are an MS365 subscriber, you could use the UNIQUE function and combine it with SUMIF or COUNTIF. Please clarify.