View Single Post
 
Old 01-06-2017, 10:42 AM
MNMark MNMark is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Jan 2017
Posts: 1
MNMark is on a distinguished road
Default 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
Reply With Quote