Hello,
my main problem is how to to append rows as columns.
For instance for the example table below, I would like to have identical compounds that were measured in the same assay type in one row.
Example table:
| Compound id | Assay type | value | assay id |
|---|---|---|---|
| 1 | B | 10 | 100 |
| 1 | B | 9 | 102 |
| 3 | F | 14 | 103 |
| 1 | B | 3 | 104 |
| 2 | F | 4 | 106 |
| 1 | F | 2 | 105 |
| 3 | F | 15 | 107 |
What I would like to get:
| Compound id | Assay type | value | assay id | Compound id #1 | Assay type #1 | value #1 | assay id #1 | Compound id #2 | Assay type #2 | value #2 | assay id #2 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | B | 10 | 100 | 1 | B | 9 | 102 | 1 | B | 3 | 104 |
| 1 | F | 2 | 105 | ||||||||
| 2 | F | 4 | 106 | 2 | |||||||
| 3 | F | 14 | 103 | 3 | F | 15 | 104 |
Thansk in advance!
Michael