Forum Discussion
MarkB1845
Jun 29, 2020Copper Contributor
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...
SergeiBaklan
Jun 30, 2020Diamond Contributor
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.