How to condense a table based on grouping columns?

[#1]

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?

[#2]

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