Forum Discussion

MarkB1845's avatar
MarkB1845
Copper Contributor
Jun 29, 2020

Group weekly data into monthly data

Is there an easy way to take weekly data and group it into monthly data.  I downloaded Google Trends for the last five years for the keywords "Private Schools" and "Primary Schools" and the google da...
excel
mathetes's avatar
mathetes
Gold Contributor
Jun 29, 2020

MarkB1845 

 

If those dates are actually Excel date fields and not text masquerading as dates, then a Pivot Table would be able to do it basically automatically. Are you familiar with that feature (Pivot Tables)?

 

If not, post a more complete sample and I or somebody else here can demonstrate.

Resources