topic Re: Merge two rows of data in Discussions

Merge two rows of data

kocemba — Wed, 17 Oct 2018 15:33:43 GMT

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!

Re: Merge two rows of data

KarenC — Wed, 17 Oct 2018 16:39:59 GMT

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.

Re: Merge two rows of data

txnelson — Wed, 17 Oct 2018 16:42:14 GMT

You can do this by using the Split Platform

Tables==>Split

Which creates the following output data table

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

And then the final data table will look like:

Re: Merge two rows of data

kocemba — Wed, 17 Oct 2018 19:47:31 GMT

Thank you KarenC!

Re: Merge two rows of data

kocemba — Wed, 17 Oct 2018 19:47:49 GMT

Thank you txnelson!