79375_en-US

liliconcom

Merge two rows of data

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!

Re: Merge two rows of dataThank you txnelson!Re: Merge two rows of dataThank you KarenC!Re: Merge two rows of data

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

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.