Hi Everyone!
I am a frog biologist who is trying to figure out how to wrangle my data into a usable form. The output from the tests on samples I did gives 3 rows of data for each sample and the program I want to use the data in requires each sample to have all of the data on one row. I have been struggling with vlookup and offset trying to figure out how to do it, but I think it will better be done with a macro. But I am much better with frogs than programming. I hope someone here can help!

Here is what the column headers for the data looks like now (for each sample, there are 3 rows of the following and data begins at A2):
RunName; SampleName; Ct; Qty; DilutionFactor; Checked; OkaytoEnter; Rerun; Okayfor+/-; Rerunfor+/-; RerunwithDilution

Data in each row for a sample will be the same, except for the Ct and the Qty values. I just need to grab the first row of data and then add the Ct and Qty for the next two rows to it. It would have column headers like this:
RunName; SampleName; Ct1; Ct2; Ct3; Qty1; Qty2; Qty3; DilutionFactor; Checked; OkaytoEnter; Rerun; Okayfor+/-; Rerunfor+/-; RerunwithDilution

Any help with this would be greatly appreciated by myself and some little frogs!