Pivottable: grouping dates

[MrsAlice]

Hello,

How do I group dates in a pivottable where the source table looks like this (dates are dd-mm-yyyy)?

[TABLE="width: 593"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Packaging[/TD]
[TD="align: right"]1-1-2015[/TD]
[TD="align: right"]1-2-2015[/TD]
[TD="align: right"]1-3-2015[/TD]
[TD="align: right"]1-4-2015[/TD]
[/TR]
[TR]
[TD]Product A[/TD]
[TD]Box[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]Box[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]Individual[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[/TR]
</tbody>[/TABLE]

Grouping just doesn't seem to be an option, unless I reformat the table to look like this:

[TABLE="width: 421"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Packaging[/TD]
[TD]Date[/TD]
[TD]Number[/TD]
[/TR]
[TR]
[TD]Product A[/TD]
[TD]Box[/TD]
[TD="align: right"]1-1-2015[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Product A[/TD]
[TD]Box[/TD]
[TD="align: right"]1-2-2015[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Product A[/TD]
[TD]Box[/TD]
[TD="align: right"]1-3-2016[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Product A[/TD]
[TD]Box[/TD]
[TD="align: right"]1-4-2015[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]Box[/TD]
[TD="align: right"]1-1-2015[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]Box[/TD]
[TD="align: right"]1-2-2015[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]Box[/TD]
[TD="align: right"]1-3-2015[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]Box[/TD]
[TD="align: right"]1-4-2015[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]Individual[/TD]
[TD="align: right"]1-1-2016[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]Individual[/TD]
[TD="align: right"]1-2-2015[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]Individual[/TD]
[TD="align: right"]1-3-2015[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]Individual[/TD]
[TD="align: right"]1-4-2015[/TD]
[TD="align: right"]8[/TD]
[/TR]
</tbody>[/TABLE]

The actual source table contains many more attributes and dates, so if possible I'd like to avoid doing this (not even sure how). Are there any alternatives?

Just to be sure we're on the same page I've included an image with how I'd like the date filter option to look below:

Many thanks in advance for any advice .

 

[RoryA]

You can't with your source table layout because they are separate fields. If you have access to power query / get and transform, then you could perhaps use that to unpivot the data to get it into your second layout.

 

[MrsAlice]

Thank you for pointing me in the right direction RoryA. I used Data -> From Table -> Unpivot other columns (microsoft.com link), selecting only columns with attributes, not columns with dates in the header. This solved my problem for this testing table, hope it works for the real deal as well!

 

[RoryA]

Glad to help.