power query help

Hi, I have a folder with multiple files which are timesheets for the week for a group of employees. Each file is 1 week.

I'd like to merge all of these files to ultimately have 1 file with the employee number, last and first name in the first 3 columns and the dates in a row. I only need the columns under the date "CODE" ( vac,s,T, DO, etc)

so it would roughly look like:


April 7 april 8 april 9
127091 Jaxton McClain vac S
145809 name name DO T

I've included 2 sample files, but ultimately there are roughly 50 sheets (Jan-Dec)

I've tried playing with power query, but I can't seem to figure it out.

If someone could possibly transform the 2 files into 1 file, I could try and firgure out what you did, so I could expand.

Hoping someone is able to assit.

Thanks in advance,

Ron