Structure your data so each row contains the part name or number, operator (optional), and the observed measurement. Parts and operators can be text or numbers.
PartNum |
Operator |
Measure |
1 |
Daryl |
1.48 |
1 |
Daryl |
1.43 |
2 |
Daryl |
1.83 |
2 |
Daryl |
1.83 |
3 |
Daryl |
1.53 |
3 |
Daryl |
1.38 |
1 |
Beth |
1.78 |
1 |
Beth |
1.33 |
... |
... |
... |