I am running excel 2013 on a PC.
I built a tracker spreadsheet and formatted it into a table. Example:
The problem is when I insert a pivot table, the empty cells seem to be removing the grouping on the pivot tables, so that all the Januarys are combined, instead of it being grouped by years and then months.
Is there a work-around?
Thanks.
I built a tracker spreadsheet and formatted it into a table. Example:
Product_Num | Team1_In | Team1_Out | Team2_In | Team2_Out |
1234 | 8/3/20 | 8/5/20 | 8/7/20 | 8/10/20 |
6789 | 9/2/20 | 9/4/40 | 9/6/20 | |
6538 | 9/15/20 | 9/17/20 |
The problem is when I insert a pivot table, the empty cells seem to be removing the grouping on the pivot tables, so that all the Januarys are combined, instead of it being grouped by years and then months.
Is there a work-around?
Thanks.