Merge two rows of data

kocemba

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!

KarenC

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.