Consolidate does not work properly

%3CLINGO-SUB%20id%3D%22lingo-sub-574477%22%20slang%3D%22en-US%22%3EConsolidate%20does%20not%20work%20properly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-574477%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20problems%20with%20consolidate%20function.%20My%20goal%20is%20to%20combine%20all%20duplicated%20in%20huge%20data%20set.%20Unfortunaltey%2C%20when%20I%20used%20consolidate%20function%20I%20lost%20nearly%205000%20values.%20An%20example%20is%20below%3A%3C%2FP%3E%3CP%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-574477%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi,

I have problems with consolidate function. My goal is to combine all duplicated in huge data set. Unfortunaltey, when I used consolidate function I lost nearly 5000 values. An example is below:

Untitled.jpg