Hi experts,

i am an newbie for the VBA and Power Query..

i will have to download reports from our old system and upload to new system everyday.. the downloaded file will have an pivot table output as below after cleaning data. what i need to be do is copy each output based on the kit no and Device to a separate CSV file. which is a duplicative task and the pivot table out put may go up 5000 rows..

each CSV files are names as KIT No & Device eg: AECWC00001 MCY

will any experts may help me to write an VBA/Macro to do this task ? copy each output group to separate CSV file in any folder ?


KIT NO Device Sequence Sum of Try
AECWC00001 MCY 9400003597193 78
SECWC00135 MCY 9400003262732 66
9400003262763 9
9400003262855 4
9400003262862 10
9400003262879 2
9400003262893 10
9400003370581 13
9400003386384 3
9400003391791 22
9400003816652 11
SECWC00136 MCY 9400003262732 3
9400003262749 2
9400003262763 25
9400003262770 12
9400003262787 3
9400003262794 14
9400003262855 13
9400003262862 1
9400003262893 12
9400003370581 6
9400003391791 9
9400003816652 3


this will be the output of the CSV file.. for eg output for SECWC000135 MCY

Header1 Header2 Header3 Header4 Header5 Header6 Header7 Header8 Header9 Header10
9400003262732 66
9400003262763 9
9400003262855 4
9400003262862 10
9400003262879 2
9400003262893 10
9400003370581 13
9400003386384 3
9400003391791 22
9400003816652 11


is this doable in power query ? or VBA ? either way i am more than happy to have a solution.

thanks in advance for your precious time and effort.