Condensing multiple rows into 1

I have a list of bars and sales per month. Months are the column headers and looks like this:

Bar Jan Feb March May

Cliff's 4,000
Cliff's 3,000
Cliff's 5,000
Cliff's 4,000
Joe's 2,500
Joe's 5,000
Joe's 3,000
Mike's 5,000
Mike's 6,000
Mike's 5,000
Mike's 5,000

But I'd like it to look like this

Bar Jan Feb March May

Cliff's 4k 5k 3k 4k
Joe's 3k 5k 2.5k
Mike's 5k 5k 6K 5k


Notice how Joe's is missing Jan, that's because not all bars report every month sometimes they skip a month and report double the next month, which is why this is giving me so much trouble. Any thoughts are appreciated and I've gone over the pivot table option 100 times and can not make that work.

Also the list contains 175,643 entries and 15,421 unique bar names and I'm going back 12 months. Please help.

at A15 (array formula)
{=IFERROR(INDEX($A$2:$A$12,MATCH(,COUNTIF(A$14:A14,$A$2:$A$12),0)),"")}

drag it down

at B15
=IF($A15="","",SUMIF($A$2:$A$12,$A15,B$2:B$12))

drag it right and down

Another variant, without formulas or VBA macro. Pivot Table only (see Attached File)

Originally Posted by Shido151

Any thoughts are appreciated and I've gone over the pivot table option 100 times and can not make that work.
Also the list contains 175,643 entries and 15,421 unique bar names and I'm going back 12 months. Please help.

You can solve your task with a simple Pivot Table, no code is required. Please see the sample attached.
Shido151-928598-example.xlsx

If this is what you are looking for, please let me know and I'll explain in detail how to create it.

Alexander Frolov, you saw my file? Your decision differs nothing from mine

Originally Posted by Serge 007

Alexander Frolov, you saw my file? Your decision differs nothing from mine

Oops, sorry, I overlooked this