Forum Discussion
Pivot Table Grouping
Good Afternoon All, I currently have two pivot tables, one has solar energy production data for a day split in hours, i.e., "Monday, 7/01/2024 - 12:00am - 1:00am" and the other has electricity us...
Hi marshalltj67
With Get & Transform aka Power Query (Excel >/= 2016 on Windows or 365 on Mac), grouped data in SourceTable every 4 rows to create the PERIOD field. The output of the query is used as data source for the PivotTable
If you have challenge adapting the query to your actual table share a sample representative workbook please