Merge rows and get infrimation in signal row

[#1]

Hello JMP community,

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

chandankishor66_0-1668439389956.jpeg 

chandankishor66_1-1668439403318.jpeg

Regards,

Chandan

[#2 · Accepted solution]

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:

Jed_Campbell_0-1668440020331.png

[#3 · Accepted solution]

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.

pauldeen_0-1668440126955.png

Stack:

pauldeen_2-1668440204584.png

Select empty cells:

pauldeen_3-1668440218455.png

Delete rows:

pauldeen_4-1668440268969.png

Split:

pauldeen_5-1668440290280.png

Result:

pauldeen_1-1668440146441.png