I tried to find a way to do this without success so I am hoping someone here can help. I have data that is coming from a database which is arranged as follows:

SN Date test parameter Data
1 1/1/2017 testname1 data1
1 1/1/2017 testname2 data2
1 1/1/2017 testname3 data3

I would like to be able to convert the data for a given serial number, SN, into the following format

SN Date Tastname1 Testname2 Testname3
1 1/1/2017 data1 data2 data3

Is this possible?

Thank you,
Mark