How do I transpose data from one spreadsheet to another?

My task is to take the first denormalised spreadsheet(Exhibit A) which stores the timesheets of employees and transpose them into a new normalised spreadsheet (exhibit B).

Exhibit B only has Leonard’s data for now but the remaining employee data will need to be appended below him.

Columns do not have any headers so will have to use index numbers but I’m unsure of how to read and write into a spreadsheet when the second spreadsheet has a completely different format?

Build a data-table with specific format, then you can add row activity to append excel.