View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] sabreindustriesga@gmail.com is offline
external usenet poster
 
Posts: 5
Default Pivot Table help!


I have columns of dates. When I try and create a pivot table using all 3 columns the column headers will not all group into columns like.

Hope someone can assist

Sep Oct Nov Dec ?


Start end close
9/17/2017 9/28/2017 10/13/2017
9/17/2017 9/28/2017 10/13/2017
9/10/2017 9/21/2017 10/6/2017
9/10/2017 9/21/2017 10/6/2017
9/10/2017 9/21/2017 10/6/2017
9/10/2017 9/21/2017 10/6/2017
9/10/2017 9/21/2017 10/6/2017
9/10/2017 9/21/2017 10/6/2017
9/17/2017 9/28/2017 10/13/2017
9/17/2017 9/28/2017 10/13/2017
11/15/2017 11/26/2017 12/11/2017
9/17/2017 9/28/2017 10/13/2017
9/17/2017 9/28/2017 10/13/2017
9/10/2017 9/21/2017 10/6/2017
9/10/2017 9/21/2017 10/6/2017
9/10/2017 9/21/2017 10/6/2017
9/10/2017 9/21/2017 10/6/2017
9/10/2017 9/21/2017 10/6/2017


Column Labels
Sep Sep Total Nov Nov Total Grand Total
Values 9/21/2017 9/28/2017 11/26/2017
Count of Start 11 6 17 1 1 18
Count of end 11 6 17 1 1 18
Count of close 11 6 17 1 1 18