manipulate data on excel

I need you to write a short script or manually do some data arrangement in excel. I have attached the file. The example is row 1. I would like you to turn the data in this row (in comma format) in the final data in the worksheet called List 1 which I have created as an example. I would like all rows from 2- 373 to be done.