Data Append power query with a common column

[magnumtuff]

Hello Everyone,

I am using power query to combine data from various excel workbook. It was successful when i append the data. I have a common column in each sheets which i have combined. 

How can i give relationship to column and append the data.

Thanks 

[#2]

@magnumtuff 

Can you share the file/sheets you are trying to do an append query?

cheers