I have a table that looks like this:
| Project | Date | System | Result |
|---|---|---|---|
| Proj1 | 07-01 | A | PASS |
| Proj1 | 07-01 | B | PASS |
| Proj1 | 07-01 | C | PASS |
| Proj1 | 07-01 | D | PASS |
| Proj1 | 07-02 | A | FAIL |
| Proj1 | 07-02 | B | FAIL |
| Proj1 | 07-02 | C | FAIL |
| Proj1 | 07-02 | D | FAIL |
| Proj2 | 07-01 | E | PASS |
| Proj2 | 07-01 | F | FAIL |
| Proj2 | 07-02 | E | PASS |
| Proj2 | 07-02 | F | PASS |
I want it to end up like this:
| Project | Date | A | B | C | D | E | F |
|---|---|---|---|---|---|---|---|
| Proj1 | 07-01 | PASS | PASS | PASS | PASS | ||
| Proj1 | 07-02 | FAIL | FAIL | FAIL | FAIL | ||
| Proj2 | 07-01 | PASS | PASS | FAIL | |||
| Proj2 | 07-02 | PASS | PASS | PASS |
I have been trying for the last few days with the crosstab function and I am not able to reproduce the results I want. Any help would be much appreciated - thank you so much!
D-PASSnot under "System1"? Note - there is no ordering to a set of rows unless you can specify it. - Stu