Collapsing crosstab rows based on identical row heading

[kgmanager]

Please see the picture above. As you can see two models appear twice in the cross tab because they have two different entries. How can I have each model appear only on one row with both entries still shown. (Essentially collapse them together)

Thanks for the help!

[June7]

Did you try doing a GROUP BY (Totals) query with the crosstab?