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!
Bookmarks