Hi I need to set up an SSIS package to import data from experiments (excel files) that are run in duplicate and triplicate this will be done on a multitude of files so it needs to be fully automated. I only need help with the data flow task not the foreach loop container task.
The table I have looks like this:
As you can see under sample name there are samples that are run in duplicates and triplicates.
What I would like in the destination table would be this: Where the columns for CT, Well and Well position are pivoted so that each sample only has one row.