Possible Do UNTIL Loop in Chart

This is my first time trying out macros and VB. I posted the excel file and pictures if that is easier for some of you. In the pictures and the excel sheet, you can see Column B and Column C. Column B has a mix of project names and people names while Column C has identifiers stating whether it is a project or a resource based on a vlookup. Column B is set up to be the persons name followed by the projects they are currently working on. Visually it is easy to understand, but I am exporting this file into a different application that needs them to be related. I was considering doing a DO UNTIL loop, but I don't know how to relate it to my data. The second image is what I want to come out of doing the loop with the peoples name next to all the projects they are working on. If anyone could help that would be greatly appreciated!


Capture.PNG
Capture2.PNG

Thank you so much! It worked perfectly