How to condense a table based on grouping columns?

JasonWS — Wed, 21 May 2025 17:52:25 GMT

I have a table that looks like this:

I want to condense the table and group by Serial, then Run so the table looks like this:

Is there a Tables or Cols menu function I'm missing that can do this, or will it have to be accomplished with a script?

Re: How to condense a table based on grouping columns?

jthi — Wed, 21 May 2025 18:04:10 GMT

Most likely this will require few steps due to the character column. This process should work, I didn't have your data so there might be same mistakes / misunderstandings.

Starting table

Create summary table (ignore the character for now)

Then delete rows which have no character (column 5) or create subset with only those which have values

And use update and join with the first two columns

JMP is most likely able to write a script for this whole process or create a workflow

topic Re: How to condense a table based on grouping columns? in Discussions

How to condense a table based on grouping columns?

Re: How to condense a table based on grouping columns?