Hello,
I have a single sheet with four columns (State, City, Start Date, End Date). I would like to create a pivot table that would show the State and City in the rows, a single row of dates on the columns, and then a count of the Starts and Finishes for each State/City combination.
Something like this.
2/27 2/28 3/1 3/2 3/3
NY
Albany
Start 4 5 3 2 1
Finish 1 4 6 3 1
Buffalo
Start 3 7 2 3 2
Finish 2 5 5 2 3
When I use the Multiple Consolidation Ranges on the Pivot Table Wizard, it consolidates the City with the Dates and only leaves the State separate. Can I limit the consolidation to just the Start and Finish Dates?
I have a single sheet with four columns (State, City, Start Date, End Date). I would like to create a pivot table that would show the State and City in the rows, a single row of dates on the columns, and then a count of the Starts and Finishes for each State/City combination.
Something like this.
2/27 2/28 3/1 3/2 3/3
NY
Albany
Start 4 5 3 2 1
Finish 1 4 6 3 1
Buffalo
Start 3 7 2 3 2
Finish 2 5 5 2 3
When I use the Multiple Consolidation Ranges on the Pivot Table Wizard, it consolidates the City with the Dates and only leaves the State separate. Can I limit the consolidation to just the Start and Finish Dates?
