Forum Discussion
Pivot Table Creation
How do I create a pivot table of the data in the "data" tab to where it then created a clickable pivot table, as exampled in "example pivot table" tab. Here it will search the columns (Estimator PM M...
jlockerbie The structure of the data isn't suited to create a pivot table from. I've used Power Query to fix that. Also needed to fix the amounts as they were in fact texts and several names that looked the same were not as they had trailing spaces. For example "Daniel" and "Daniel ".
The attached file included a PT in the tab with your example and two extra tabs with the details created by double clicking inside the PT.