Dynamic Column Headers from multiple rows

Hi,

Thanks in advance for any help.

I am bringing data into power bi from excel. This is an export from a third party so i dont have any control over the source format. 

The data has some person information, then activitiy codes for AM and PM each day, for the last 2 working weeks. Example data below:

Within power bi power query I need to format the columns so that it ends up like the following:

Alternatively, the following format would also work, and mayybe even better:

I need to take into account that this export is taken weekly, and each time the dates are different, so I need to add AM and PM as suffixes to column headers which change. 

Its also complicated by the fact the person information are on the same row as the AM and PM, not the dates. 

I am happy to include the example source spreadsheet and desired outcome, and also a .pbix with the source already loaded, but it looks like uploading those files is not supported here. Please let me know how I should do this. 

Any help very much appreciated.