Loop A1 value based on columns with value

Closed
Posts
1
Registration date
Tuesday July 4, 2017
Status
Member
Last seen
July 4, 2017
-
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.
Thanks