Single line macro required

NardusMamba Posts 1 Registration date Tuesday February 24, 2015 Status Member Last seen February 24, 2015 - Feb 24, 2015 at 08:56 PM

I have data in this format:

Please help me with a macro that will convert it to this format :

This macro should run until all the data on the sheet have been converted to a single line per person

I have just started teaching myself VB so be gentle :)

Thanks stax!