368547_en-US

liliconcom

Move data from a row to a column for duplicates, then remove duplicates

New JMP user here. I know how to do this in Excel, but am not sure how to in JMP.

 

Here 's my dataset:

Column1	Column 2	Column 3	Column 4
AAA	123456	ABC	P
AAA	123456	ABC2	10.72
AAA	234567	ABC	P
AAA	234567	ABC2	8.9
BBB	345678	ABC	N
BBB	345678	ABC2	0.01
BBB	456789	ABC	P
BBB	456789	ABC2	21.2

 

Here's what I want my data to look like:

Column1	Column 2	Column 3	Column 4	Column 5
AAA	123456	ABC	P	10.72
AAA	234567	ABC	P	8.9
BBB	345678	ABC	N	0.01
BBB	456789	ABC	P	21.2

 

Any and all help is greatly appreciated!

Quality and Process EngineeringRe: Move data from a row to a column for duplicates, then remove duplicates

Thank you so much! That worked well!

 

 

Re: Move data from a row to a column for duplicates, then remove duplicates

You can use 

     Tables=>Split

pull down menu to do this

In the Split dialog box,

    Select Column 3 as the Split By column

    Select Column r as the Split Columns

    Select Column 1 and Column 2 as the Group columns