Using a macro to convert groups of rows to columns

Hi,

I'm a first timer here

I have a list of data currently sorted into rows. I have group names and then a number of entries in the group - the number of entries in a group varies from 1 - 10. I need to 'transpose' the data in rows into columns in another worksheet. It's a bit tricky to explain, so I have attached a copy of the spreadsheet for an example. I could do this manually, but it would be a laborious task being that I have a max of 200 names and 75 or so groups.

Does anyone have any ideas how to go about doing this? In my head I know what I would like the macro to do, but I can't put it into effect.

Thanks in advance if anyone can help. It would be much appreciated.