Filling a cell with only the last available data measurement of a sanple

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