Hi

I am new to vba and am trying to solve the below issue. Any advice will be greatly appreciated.

Original

01012014 DAVE JOHN
02012014 MAT
03012014 CHRIS MIKE PHIL

What I want

01012014 DAVE
01012014 JOHN
02012014 MAT
03012014 CHRIS
03012014 MIKE
03012014 PHIL