Consolidating Data from a single list

[Jettek]

Hello!

I have a multiple lists of items that I've combined into one

At the moment it looks like this

I'm wondering if there's a way to consolidate the list.
I've tried the consolidate function, but I can't quite seem to get it to work at least not the way the list is

(Extra detail: The tops of the columns have headers so it can be filtered)

Thanks!

[#2]

@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.