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

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

CMG — Sat, 10 Jun 2023 23:27:16 GMT

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

Here 's my dataset:

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

Any and all help is greatly appreciated!

txnelson — Wed, 17 Mar 2021 12:52:59 GMT

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

CMG — Wed, 17 Mar 2021 13:42:36 GMT

Thank you so much! That worked well!