Get the Unique Items for each Month Sum

[Legacy 143009]

Hi,

I am currently using XL2019 so I can't go for UNIQUE-FILTER.
I have a table like this starting from A2:

Apple	Jan	300
Orange	Jan	200
Banana	Jan	100
Apple	Jan	100
Orange	Jan	100
Apple	Feb	200
Apple	Feb	100
Banana	Feb	200

The desired result is:

Apple	Jan	400
Orange	Jan	300
Banana	Jan	100
Apple	Feb	300
Banana	Feb	200

Is this doable without a helper column? I am trying to move over the classic unique formula but COUNTIF function isn't accepting the array as a range.
=INDEX($A$2:$A$9,MATCH(0,COUNTIF($A$2:$B2&$A$1:$A1,$A$2:$A$9&$B$2:$B$9)),0))
I need the formulas only for Columns A and B in the 2nd table. I can handle Column C if I got those two columns. It would be a simple COUNTIFS.

Thanks a lot!

 

[JvdV]

Any particular reason you didn't opt for a pivot table? Or would that be a good alternative for this usecase.

 

[Legacy 143009]

I was not able to configure pivot table layout like the desired output. I am open if there is a way..

 

[RoryA]

A tabular layout pivot with no subtotals would look like your desired layout.

 

[Legacy 143009]

I never did a tabular pivot before. Can you describe in few steps, plaese? I can figure out the rest myself.

 

[JvdV]

With a little bit of fiddling, this is what my pivot table looks like:

Here is a quick 'How-to" on creating a tabular layout. Maybe that is close enough to what it is you are trying.

 

[Legacy 143009]

OK; I guess I can live with this. One last question:
I want to filter the results according to year. And the year is the sheet name. Is there any way to trick pivot table like a calculated field?
(original date data has year information)