How to reorganize data in Excel file [Mac OS]

I have a rather large excel file that contains data that is not organized in the manner that I would like it to be. As seen in the attached workbook, it contains the "Name" and various other parameters organized into two columns. I would like it to be organized so that it looks like the format in the attached image.

What's the best way to go about doing this? The file I have currently has over 6500 rows in it, so automation is key.

Thanks!

Create a new sheet and use this formula as demonstrated in my attachment.

Formula:

Please Login or Register  to view this content.

Although your platform is Mac OS, your question is not specific to the platform so I'm moving your thread.

Which solution did you use?

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.