Hello JMP community,
How to merge multiple rows with the same name and obtain its value in a single row.
Regards,
Chandan
Accepted Solutions
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:
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:
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:
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: