Merge rows and get infrimation in signal row

Question

Hello JMP community,

How to merge multiple rows with the same name and obtain its value in a single row.

Regards,

Chandan

Jed_Campbell · Accepted Answer

Assuming there's only one valid entry for each column in each batch number (this might be an invalid assumption), you could use the tabulate function to create a new table. Simplified example below:

pauldeen · Accepted Answer

Stack your last 4 columns using the Batch # as the group variable.

In the new table, right click the empty cells and delete the rows containing empty cells.

Split your table again using Batch as the group.

Stack:

Select empty cells:

Delete rows:

Split:

Result: