Merging two rows under one row heading

Hello all,

I'm trying to create an example sales report and generate a simple pivot table from it. However, the pivot table omits the second row. Is there a simple way to combine the two rows under the "May" heading? I've tried merging May into one cell, bu it still didn't work. Unfortunately, I do not know any SQL or VBA yet.

Any help would be appreciated!

Capture.JPG

Hi,

I don't think you need to merge cells here. I guess if you update the month name for the 2nd row the Pivot should work.