CFMX/HTML Table formatting

Hey all, so here's what i'm trying to figure out.

I've got a list of data coming from a query, here's an example of what it looks like

TypeA - 1
Type B - 1

TypeA - 1
Type B - 2

TypeA - 1
Type B - 3

TypeA - 1
Type B - 4

TypeA - 2
Type B - 2

TypeA - 1
Type B - 3


TypeA - 3
Type B - 1

etc.

Now what i'd like to do is this

Type A - 1
Type B - 1, Type B - 2, Type B - 3, Type B - 4

Type A - 2
Type B - 1, Type B - 2,

Type A - 3
Type B - 1


Etc.

I'm not sure if i've got to loop over my query or toss the results into an array and deal with it, just looking for some advice on how to attack the problem.

Thanks
Caden

Nevermind, I just used the group ability of CFoutput.