Help Extracting Data- Probably VBA for looping?

Hi everyone,

I am very rusty at my Excel skills, and it seems like I may need to use VBA with this one. I have a spreadsheet that is about 4000+ rows of data: Names, Access Levels, and card numbers. The problem is that there is one name associated with multiple rows of data, and it isn't consistent. Basically I need to take this data, and have the person's name, access levels, and card number in column format so that I can concatenate and put into CSV format.

In the attached workbook, you'll see the raw data sheet, and then the desired result page. Is there a way to use the vlookup on a merged first cell with multiple adjacent rows, and dump that data into multiple columns like second example?

Any assistance is greatly appreciated. I'm trying to help out a friend, and am now stuck on trying to figure it out because I want to.