topic Re: Merge rows and get infrimation in signal row in Discussions

Merge rows and get infrimation in signal row

chandankishor66 — Fri, 09 Jun 2023 16:02:31 GMT

Hello JMP community,

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

Regards,

Chandan

Re: Merge rows and get infrimation in signal row

Jed_Campbell — Mon, 14 Nov 2022 15:34:09 GMT

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:

Re: Merge rows and get infrimation in signal row

pauldeen — Mon, 14 Nov 2022 15:38:21 GMT

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: