Forum Discussion

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

SergeiBaklan

Diamond Contributor

Jun 30, 2020

MarkB1845

In addition to mathetes comment - you may transform texts to dates by selecting dates columns, Data->Text to Columns, on first step of the wizard select Date type and MDY.

Insert PivotTable and group on months. Not sure which aggregation to use.

Schools trends.xlsx111 KB