With a slightly changed schema and data:

ID sampleindex comp value

-------------------------

1 1 100 4

2 1 200 7

3 1 300 3

4 1 100 10

5 1 300 2

With the help from those that...

And finally I forgot to say that the comp column is not sequential in anyway. So the values 1, 2, 3 should have been "more" random.

I forgot to mention that the heading of the result also comes from the table. So the different values from the comp column must result in a column for each,...