Consolidate does not work properly

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: