Quote Originally Posted by p45cal View Post
Are these pivot tables normal 'old' excel pivot tables or Power Pivot tables?

Is the cleaning data process something you do to the source data of the pivot tables (do you perhaps create the pivot tables yourself? (because if you have the source data there may be faster ways of getting the output you need, without pivot tables, for example with Advanced Filter or just a simple query))

Even assuming you have these pivot tables supplied to you 'as is', vba can manipulate and get data from pivot tables quite well and we should be able to use to that produce these csv files quite easily.
One more question; you have the Sum of Try column in the Values area of the pivot, is the sum in fact always only one record from the source data?

A workbook with your pivot (and your source data too if possible) would be really. really useful and answer a lot of questions. See if you can't supply one here.
hi,

its just a regular old pivot table. not a power pivot. cleaning data means that i do add some columns and remove blank rows manually and get into to a normal table. the source table has the duplicating kit no, device, sequence and no of try in no order. so basically its a groping based on the kit no, device and sequence to get the total no of try to see how many times tried in the with device.


my source data looks like the below table

Source.jpg

thanks for your attention