If you are you using SQL you may be able to write a stored
procedure to do it. Perhaps a cursor for the outter query and
pass the distinct One values to the inner query along with the
count of Twos. The inner query will construct the field Two
containing x number of entries separated by commas. I don't
know if I am explaining this correctly.

I know you could easily do it in VB. Would that be an option?