Pivot Tables - Question about slicers

[scoscione]

Hello all,

I have a database which I need to convert and summarize as a pivot table. Until there all fine, but my issue is the data is organized in columns, meaning each column represent a month.
I wanted to have a slicer that is capable of automatically change the month - in this case the column in which the data is being read. Does any one know if this is possible

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Vendor[/TD]
[TD]Country[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[/TR]
[TR]
[TD]Charles[/TD]
[TD]USA[/TD]
[TD]100[/TD]
[TD]110[/TD]
[TD]120[/TD]
[/TR]
[TR]
[TD]Lin[/TD]
[TD]China[/TD]
[TD]500[/TD]
[TD]100[/TD]
[TD]90[/TD]
[/TR]
</tbody>[/TABLE]

So basically once, the table above is summarized in a pivot I have to manually select which months am I reading, while I wanted to have a slicer that automatically updated which column is the data being read.

Thanks,
S

 

[SpillerBD]

Excel is based on columnar/transactional data. Your data confounds that method already being in a "Pivot Table" like layout. Your data needs to un-pivoted first.
You can find macros to perform the unpivot as well as a method using the PivotTable wizard.
However, if you have Excel 2016, there is a new feature for everyone called Get & Transform which has a Unpivot capability to it. Get & Transform was Power Query in previous Pro+ and Enterprise versions of Excel.