Hi,
I have the following "stacked" data table in JMP;
| Test ID | Sample Type | Result |
| Test_ID_1 | Sample | 10 |
| Test_ID_1 | Sample | 12 |
| Test_ID_1 | Sample | 11 |
| Test_ID_1 | Sample | 14 |
| Test_ID_1 | Sample | 9 |
| Test_ID_1 | Control | 11 |
| Test_ID_2 | Sample | 9 |
| Test_ID_2 | Sample | 8 |
| Test_ID_2 | Sample | 10 |
| Test_ID_2 | Control | 14 |
| Test_ID_3 | Sample | 13 |
| Test_ID_3 | Control | 15 |
| Test_ID_4 | Sample | 9 |
| Test_ID_4 | Sample | 7 |
| Test_ID_4 | Control | 12 |
I would like to generate the following table from the above table by unstacking;
| Test ID | Sample Type = Sample | Sample Type = Control |
| Test_ID_1 | 10 | 11 |
| Test_ID_1 | 12 | 11 |
| Test_ID_1 | 11 | 11 |
| Test_ID_1 | 14 | 11 |
| Test_ID_1 | 9 | 11 |
| Test_ID_2 | 9 | 14 |
| Test_ID_2 | 8 | 14 |
| Test_ID_2 | 10 | 14 |
| Test_ID_3 | 13 | 15 |
| Test_ID_4 | 9 | 12 |
| Test_ID_4 | 7 | 12 |
The stacked data contains a varied number of samples for a given control. Sometimes there is a 1-to-1 correlation between sample and control but more often there is a many samples to one control. The number of samples can vary from one to n but there is always just one control. I am using JMP 16.0.1.
Thanks,
Tim
