Hi,
I was wondering if anyone had encountered a similar problem and how they resolved it. I have a table set out like this in my protocol:
| probe_id | Array1 | Array2 | Array3 | ArrayN |
|---|---|---|---|---|
| A | 1 | 1 | 3 | 3 |
| B | 2 | 2 | 4 | 4 |
| C | 1 | 3 | 4 | 4 |
..etc
I want to sort the columns (not rows) by the order specified in another table:
| Order | Array |
|---|---|
| 1 | Array3 |
| 2 | Array5 |
| 3 | Array1 |
.. etc.
I've tried a few ways but can't get close to doing it, could anyone suggest a solution?
Thanks,
Liz
