Parse rows to separate columns

[kunvai1]

Hi,

I have data like this :

DONOR    BIRTHDATE     GENDER    ETHNICITY    Name             Value
86            1963-10-16          M                  CAUC        TEST_DATE  2017-12-08
86            1963-10-16          M                  CAUC        VALUE           NEG
86            1963-10-16          M                  CAUC        TEST_DATE  2018-05-22
86            1963-10-16          M                  CAUC        VALUE           NEG

I want one row for each donor and the columns would be “donor ID”, “DOB”, “gender”, “ethnicity”, “date of titer”, “result of titer”, “date of titer”, “result of titer”, and repeated for all times the donor has been tested with the oldest testing first and progressing to the newest testing to the right.

The output should be:

DONOR    BIRTHDATE     GENDER    ETHNICITY  TEST_DATE1   Value1   TEST_DATE2    Value2

86            1963-10-16          M                  CAUC       2017-12-08      NEG         2018-05-22       NEG

Any help would be appreciated!

Thanks,

Vaishnavi

[caltang]

Like so:

[kunvai1]

Hi,

Thank you for your reply!

For some reason, the second cross tab doesn't show same results as yours.

I am doing the same way.

[caltang]

The size and nature of your data looks different from your sample. Do you mind uploading the data? Then what is your expected output?