Quote Originally Posted by newuser17 View Post
i have uploaded the sample source data and output pivot table and final output csv files.
Right, I can work with these. I'll be looking at this on and off. In the interim, you've confused me a bit with your AECWC00001 MCY.csv file; there are 2 records, both for 9400003597193 in the Header1 (Sequence ID?) field and 2 values in the Header3 field (Try count?) of 1 and 3. Could you confirm this is a typo or mistake just so I'm sure I'm not missing anything. I expected this csv file to contain only one record, 9400003597193 and 71 under the respective headers??

The other other csv file is empty, which is reasonable since the sample data contains no data for that Kit No./Device combination; do you want to produce such empty files too?