Hi there,
I have data from laboratory samples in an Excel sheet.
They are all samples that have been measured in duplo or more repeats.
In the case of a duplo measurement the results will be copied in one row in another sheet.
In the case of a triplo measurement 2 results will be copied beneath each other and the third measurement will be copied in the second row next to the second measurement.
The question is however : how am I gonna fix this with formulas.
An example of how I want it to be in the sheet is shown below.
I can't submit a link to an excel sheet because of the forum rules to new members.
A B C D E
1 Sample ID Analysis Data Sample ID Repeated results Reported results
2
3 Sample 1 10 Sample 1 10 11
4 Sample 1 11
5 Sample 2 20 Sample 2 20
6 Sample 2 22 22 23
7 Sample 2 23 Sample 3 30
8 Sample 3 30 33
9 Sample 3 33 34 35
10 Sample 3 34 Sample 4 50
11 Sample 3 35 53
12 Sample 4 50 55
13 Sample 4 53 56 57
14 Sample 4 55
15 Sample 4 56
16 Sample 4 57
I hope someone can help me..
Maybe there are helpful Excel functions for this.
Greetings,
Harrie
Bookmarks