I have been doing a lot of thermofluor assays for determining binding affinities. This necessitates getting the raw fluorescence values organized into a different column for each sample. Unfortunately, QuantStudio Design and Analysis software is not so kind as to export the data in this manner. Instead, it exports the data all in one column, with separate samples stacked on top of one another in a workbook ~infinity rows deep. There is at least a well ID and sample name column that lists this info next to each temperature and fluorescence value.
Is there a way to write an excel script that would be able to organize each samples' data into columns like this by referencing the well ID associated with each sample? Or some other way?
Thank you so much, Yuhta! This is amazing and will save my colleagues and I so much time.
Much appreciated,
Nathan
- Badges
- Science topic
- Similar topics
- Analytical Chemistry
- Column