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

CMG

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!

txnelson

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