Single line macro required

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

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!