Is this possible or practical?

Being a somewhat newbie  is  tryng to do the following possible or practical?

I select 4 fields.

     Group - Qty - Size - Item   order by group

1. AA  2S        AAS
2. AA     3    M        AAM
3. BB     1    XL       BBXL
4. CC     1    S         CCS
5. CC     4    L         CCL
6. CC     2    XXL     CCXXL

I am bringing the result set to a  vb webservice  where I want to display to the user just the group and sizes available(> 0) for that group.

Group         Size (dropdownbox which contains the item number as the value)

AA     S,M    (select values AAS, AAM)

BB XL

CC S,L,XXL    

  I have tried to manipulate this on the webservice side but with forward only, can't seem to get it. Didn't know on Tsql side, if I can get the individual group with the  size and associated item numbers for that group,into a single record for each group.

thanks

mark