Consolidate large data

Hello, can anybody can help me with this issue please!
I have two columns with 85000 rows each! On the first column are located the serial numbers of the articles, on the second are the pcs that are sold/its export file from our erp/ !
I tryed to use consolidate function by default to see how many pcs of each article are in the list/there are lot of dublicates /
Unfortunetly everytime when i try to use consolidate nothing happens, excel try to do something, start thinking, stucks and when finish nothing happens... Its look like the data is too large or something else. Can you sugect me other way to do this please? Thank you in advance

When i split the articles to 4000 on different list it works but if i do this i will split it all night

Thank you dosydos,

There is the table that im using.
Yes, i need something like Pivot table but this is just working file and i will use the data for other main table.
I need to remove the dublicates and count their specific values
For example
Art1 10 pcs
Art2 23 pcs
Art3 12 pcs
Art1 8 pcs
Art3 8 pcs

New data
Art1 18pcs
ART2 23pcs
Art3 20pcs



Нов Работен лис&#.XLSX

Its just 10000 rows because the file is more than 1mb .
Thank you again

OMG, Thank you very much! Its that i need of
If i met you one day in personal i will buy you beer

BR

Power Query

Please Login or Register  to view this content.

Pls try this formula

Formula:

Please Login or Register  to view this content.