floggingmolly
Board Regular
- Joined
- Sep 14, 2019
- Messages
- 167
- Office Version
- 365
- Platform
- Windows
I have a worksheet with 3 columns. Column A and B are dates, and column C is an ID#. Column A has a start date, B is end date. For example Column A1-A7 is 1/3/2022, Column B1-B7 is 1/10/2022, and so on. I need a pivot table that shows like this:
Begin Date End Date # of IDs
1/3/2021 6/3/2022 5
1/10/2021 6/10/2022 7
1/17/2021 6/17/2022 20
and so on fir each date range. I can't figure out how to get the Begin Date and end date in 2 columns beside each other in the pivot table. Any help would be appreciated.
Begin Date End Date # of IDs
1/3/2021 6/3/2022 5
1/10/2021 6/10/2022 7
1/17/2021 6/17/2022 20
and so on fir each date range. I can't figure out how to get the Begin Date and end date in 2 columns beside each other in the pivot table. Any help would be appreciated.