i am not sure how to describe this so bare with me
basically i have a VISIT TABLE
with
VisitID
PatientID
VisitType (1st Trimester, 2ndTrimester, etc)
and then columns pertaining to the visit
We are trying to do a longitudinal study where we compare each visit type data to itself to be exported to excel so it would look like this all in one column based on patientID
PATIENTID | 1st Trimester | data | 2nd Trimester | data |
is there a way to query this so the visit types and data are all in the same row based on patient id