ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivot Table help! (https://www.excelbanter.com/excel-worksheet-functions/453489-pivot-table-help.html)

[email protected]

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


All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com