I guess I am trying to do a pivot table of some sort but I can't figure it out.
I am trying to check each column for a missing value, then aggegrate the missing values grouping it by PatientID.

Thanks in advance.

| Lab | PatientID | LabTime | Glucose | Protein | Sodium | TestMissing |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | 1 | 10am | 23 | 43 |  | Sodium |
| 2 | 1 | 11am | 23 |  | 34 | Protein |
| 3 | 2 | 10am |  | 43 |  | Glucose |
| 4 | 2 | 12am | 23 |  | 23 | Protein |
| 5 | 2 | 1am | 23 | 43 |  | Sodium |

Expected table

| PatientID | Another header |
| --- | --- |
| 1 | Protein, Sodium |
| 2 | Glucose, Protein, Sodium |