Consolidating Data from a single list

%3CLINGO-SUB%20id%3D%22lingo-sub-1646908%22%20slang%3D%22en-US%22%3EConsolidating%20Data%20from%20a%20single%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1646908%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20multiple%20lists%20of%20items%20that%20I've%20combined%20into%20one%3C%2FP%3E%3CP%3EAt%20the%20moment%20it%20looks%20like%20this%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20414px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217195iE78CAD05FEC7FD3C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20wondering%20if%20there's%20a%20way%20to%20consolidate%20the%20list.%3CBR%20%2F%3EI've%20tried%20the%20consolidate%20function%2C%20but%20I%20can't%20quite%20seem%20to%20get%20it%20to%20work%20at%20least%20not%20the%20way%20the%20list%20is%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(Extra%20detail%3A%20The%20tops%20of%20the%20columns%20have%20headers%20so%20it%20can%20be%20filtered)%3CBR%20%2F%3E%3CBR%20%2F%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1646908%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1646954%22%20slang%3D%22en-US%22%3ERe%3A%20Consolidating%20Data%20from%20a%20single%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1646954%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F786557%22%20target%3D%22_blank%22%3E%40Jettek%3C%2FA%3E%26nbsp%3BWhat%20exactly%20do%20you%20mean%20by%20%22consolidate%20the%20list%22%3F%20Do%20you%20want%20a%20list%20of%20unique%20items%20only%2C%20and%20perhaps%20sum%2Fcount%20how%20many%20of%20each%20there%20are%20in%20the%20list%3F%20If%20so%2C%20a%20pivot%20table%20could%20do%20that.%20Alternatively%2C%20is%20you%20are%20an%20MS365%20subscriber%2C%20you%20could%20use%20the%20UNIQUE%20function%20and%20combine%20it%20with%20SUMIF%20or%20COUNTIF.%20Please%20clarify.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello!

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

At the moment it looks like this

Capture.PNG

 

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!

1 Reply

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