Single line macro required

[Closed]
Report
Posts
1
Registration date
Tuesday February 24, 2015
Status
Member
Last seen
February 24, 2015
-
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!