All the files exist out of three columns, The first one is for every file the same and the second one are the different results. ( so I need the first one, and all the second columns). I dont know the names in advance because they can change from experiment to experiment..., but also the total number of files changes but thats easy to look up.


To better Explain, S01, S02 is the number of the measurement, So it is possible I measure 10 times in a row the same thing, for example PCB, but it ia also possible I measure first 1 Reference, 3 Pcb, 2 A en 2 B, that woul give me a data set with names REFS01, PCBS02, PCBS03, PCBS04, AS05, AS06, BS07, BS08, You understand what I mean:p

Then I want in Excel a sheet with PCBS together, another sheet with REFs together, another sheet with As together ...