Merge rows and get infrimation in signal rowHello JMP community,
How to merge multiple rows with the same name and obtain its value in a single row.
Regards,
Chandan
Advanced Statistical ModelingData Blending and CleanupRe: Merge rows and get infrimation in signal rowStack 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:
Re: Merge rows and get infrimation in signal rowAssuming 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:
