Combining / Totalling Rows

[jwong]

Hello!
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

[WillowMobileSys]

jwong:

or show show one row per value so that i can edit it

What values re you looking to edit?

[jwong]

There is also a location column (not shown)

[Izzat_Safrah]

@jwong

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