Loop A1 value based on columns with value

krbymntj Posts 1 Registration date Tuesday July 4, 2017 Status Member Last seen July 4, 2017 - Jul 4, 2017 at 11:30 PM
Hi guys, hoping you can help me achieve what I want to display in MS excel 2013.

What I have is this

What I want to achieve is this

Please help.