Merging column data underneath existing data in Power Query

[Anonymous]

Hi guys, I've got data that was given to me that I want to combine, I do not mean to merge the columns, I mean to add the data underneath. How can I do this? I will then add a column to differentiate them by site(the reason they are seperate in the first place). They all sit in the same sheet. 

Thanks

[ImkeF · Accepted solution]

Use Append queries instead. You'll find the button below the merge-button.