Converting rows to separate colums
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
|