Merge Multiple Rows into One and Output in New Sheet

[NewbiePLK]

Hey Gurus,

I am just trying to learn VBA but need help with a report. I have a file of data with multiple rows for one person that I need to then report out as a single row with all of the data for that person on a new worksheet. Each person can have up to 7 rows of data while others have 8. I need those 7 rows to be become a single row. Please see the attached document with the raw data that I begin with on tab -- Raw Data and the desired output on the Output tab. I would love some help with a macro that can generate the output for me.

Any help will be appreciated

[dflak]

If you are just trying to learn VBA, then I'll include some "tips" along with the code.

[NewbiePLK]

Thank you very much for your help and the resources to help me as I develop proficiency in VBA. The code works great!