Combine Data from Multiple Excel Files in a Single Excel Sheet

[Cariasvar]

Good morning guys,

I came with another doubt.

I'm trying to combine data from two different excel files into a single excel sheet. The data that I have from these two different sheets don't have the same structure but they have common data. In one sheet it has different columns than in the other one.

I'm trying to do it with power query following a video on youtube but then I get to this error: "An error occurred in the ‘Transform File’ query. Expression.Error: The key didn't match any rows in the table."

I've been trying for a while and doing some research but I'm not able (I don't have all the knowledge) to continue with this process.

I'll attach both files to see if someone kindly enough could help me with this issue.

Regards and thank you.

[alansidman]

I did a simple append and it seems to have arranged the data correctly, but I am not sure. Suggest you review the results and see if this worked for you.