Combining / Totalling Rows

I would like to condense multiple rows (that represent inventory items) so that only the item name and total quantity is shown.

See below, i would like to leave out the numbers that are crossed off in red and only show the lines circled in blue.

Thank you!

edit: i know that i can use the group function, but i would like to either combine the rows, or show show one row per value so that i can edit it

What values re you looking to edit?

There is also a location column (not shown)


You can leave out the Numbers if you add Column name [_RowNum] in group by.

And for show location name you can add what you want to show in Column Order

1 Like