Converting rows to separate colums

MNMark · #1 01-06-2017, 10:42 AM

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

xor · #2 01-06-2017, 11:41 AM

It is a very small example you give.
What about uploading the file with actual data?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail merge into table with two colums and several rows	kathriiin	Mail Merge	3	03-30-2015 07:06 AM
Is it possible to copy non-contiguous rows of a Table and paste them as a separate Table in Word?	Joey Cheung	Word Tables	1	08-12-2014 05:15 PM
entering data in separate rows within a cell	drsuis	Excel	1	02-19-2013 04:36 PM
Can I use the filter function to separate letters into separate files?	drhauser	Mail Merge	2	12-14-2011 02:18 PM
Any easy way to separate a Word document into separate files?	SamHelm	Word	0	08-21-2010 05:29 AM