Power Query Vertical Sum

Copper Contributor

Hello,

As you can see I have a bunch of the same items, with different quantities.

 

I need to sum up those quantities and have only e.g.:

Carrots 250

Books 5

Paper 100

Excetera.

 

Anybody can help? Thanks

image.png

3 Replies

Hi @furlapie 

 

Right-click on column [Item] > GroupBy... After that you should find your way

Oh my god thanks a lot!
That was quick.

Cheers

You're welcome @furlapie