Excel: collapse and and the value based of column data?

Concerning about ONE PARTICULAR, 000 rows on this.

_ YOUR _ B _C
JUST ONE $2 1-2 CA
TWO $4 1-2 CB
3 $1 1-2 CA
5 $2 1-3 CA

C is a lot like a most important catagory and also B is like a sandwich catagory.in the particular example row 1 and 3 get matching colums B and also C so i want to collapse all which have two mattching colums as well as add on-line of people who matched

i’m sure i the ways is i’ll sort simply by B next sort through C as well as just place a strip and autosum less than ones that will match however thats just solution to many rows to do.

i is able to see why any pivot stand would “sort regarding ” operate.(what model of excel)
but when you finally make a person’s pivot table
then duplicate the pivot table to some new published, and all you have to carry out is add the blanks within the C column.