Repeat one column number of times there is text in another

Originally Posted by ramananhrm

Please try this file.

This seems to work, but does it work if one group has more then 3 members. I mean how can i expand the data that it uses ? Any help is much appreciated.