Pivot table grouping on month when dates are in columns

See attached.

I can group by month if the dates are in rows, but not if the dates are in columns.

Do I need some intermediate table to make this work?

Appreciate any help!

Thanks