Here's a better, more flexible goal. Add a fifth variable, GROUP, that will be 1 when NAME is A, B, or C. GROUP will be 2 when NAME is D, E, or F.
This will easily let you create the report you want, and adds to your data the relationship between a NAME and a GROUP.
... View more