Power Query technology in Excel allows you to unpivot static tables & access your tables, perform a transformation & create a PivotTable from the transformed data.

I have a Pivot table in Excel and can't seem to find a way to return it to being a flat file.The Excel document is generated by a software program and makes an excellent looking Pivot table, but ...