Grouping categaries, but not by marking

I am trying to group categories, but not by using marking. I am woking with flavor systems where I am comparing flavor levels between samples. We are interested in the individual components as well as the grouping of the components by character.

The example data shows compounds as well as the groups we have assigned them. Typically, we have to spend a lot of time in Excel organizing the data after it gets exported from Agilent Mass Hunter software before we can bring it into Spotfire. Just wondering if we could stream line the process.



File tibco_question.xlsx13.01 KB

(2) Answers