Moving data from a columnar table to a record based table

Not sure that's a great title, but it's the best I could come up with right now.  I created the below table for ease of end-user data entry.  (To increase adoption rate and reduce pushback.) I w...