Lookup data that has repeated lookup values

Repeat example.xlsx

I have a Pivot Table that returns the dates that people were in attendance.

My goal is to have the name repeated by the "Count of Days" vertically, with the day they were in attendance next to their name. (Example)

Names Date
Megan 9/1/14
Megan 9/2/14
Darrin 9/1/14
Darrin 9/2/14
Darrin 9/4/14


I have managed to find a function that will repeat the names the correct amount of times. Now I need to bring the dates over. I have attached an example of the spreadsheet with the work I have already done.

Thank you in advance for any assistance.

Megan

I added a helper column that you can hide, but I think this accomplishes what you wanted.

hoyasaxa215 Thank you for your quick response. I worked like a charm in my original sheet when I moved it over. I appreciate the help.

Richard B. - You are correct, I copied the table in my example from a Pivot Table in my original file. Thank you for your reply as well.

I believe this is solved.