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