Merge two rows of data

[#1]

Hi

I have a list of patient ID's, diagnosis and diagnosis date. I have it like this right now:

ID	Label	Row 1	Row 2	Row 3	Row 4	Row 5	Row 6	Row 7	Row 8
1	Diagnosis	x	x	y	y	z	z	x	x
1	Diagnosis date	01/01/2000	01/01/2001	01/01/2002	01/01/2003	01/01/2004	01/01/2005	01/01/2006	01/01/2007
2	Diagnosis	x	x	y	y	z	z	x	x
2	Diagnosis date	01/01/2000	01/01/2001	01/01/2002	01/01/2003	01/01/2004	01/01/2005	01/01/2006	01/01/2007

I am trying to get it like this:

ID	Diagnosis date	diagnosis	Diagnosis date	diagnosis	Diagnosis date	diagnosis	diagnosis date	Diagnosis	diagnosis date	diagnosis
1	01/01/2000	x	01/01/2001	x	01/01/2002	y	01/01/2003	y	01/01/2004	z
2	01/01/2000	x	01/01/2001	x	01/01/2002	y	01/01/2003	y	01/01/2004	z

Can you help?

Thanks!

[#2 · Accepted solution]

You can use the table split:

Tables > Split

Then Split By = Label

Split Coumns = Rows

Group = ID

I like to click the "Keep dialog open" option as it often takes a couple of rounds to get things just right.

[#3]

Thank you KarenC!

[#4 · Accepted solution]

You can do this by using the Split Platform

     Tables==>Split

split1.PNG

Which creates the following output data table

split2.PNG

The order of the rows is based upon the alphabetical order of the Label column.  So if you want to change that you can use the Value Ordering Column Property to change the order

split3.PNG

And then the final data table will look like:

split4.PNG

[#5]

Thank you txnelson!