Combining few excel data into one excel (in the specific format)

[Jenny245]

Hi, 

I have 5 excel data files (New Workers 1-4), which I would like to combine and extract relevant data and transfer it to the excel file (register-Test). How should I do it in power queries.

Thanks

Jenny 

[#2]

@Jenny245 

You may use From Folder connector

Import data from a folder with multiple files (Power Query) - Excel (microsoft.com)

Power Query Get Files from a Folder • My Online Training Hub