Rearranging data from multiple rows to columns

Hi guys,

I have datasets converted from PDF to Excel as in the attached workbook. Worksheet "ZOTA" contains an example of the data as converted. I need to rearrange the data in this spreadsheet to provide the results as depicted in sheet "Final". Important to remember is that a "member" may have any number of vehicles registered. Is there an easy way to do this? I have approximately 8000 lines of the data as in "ZOTA" and need a easy way to rearrange this data as soon as possible.

Your assistance will be appreciated.

Regards

Danie