Appending data using power query

ajl_ahmed Thanks for uploading the files, but allow me to ask a few more questions.

1) How familiar are you with PQ?

2) Are you wanting to combine 4 files or all files in a folder?

If the latter, you can't do that with PQ on a Mac, as easy as you can on a PC where you can connect to all files in a folder. That's not (yet) supported by PQ for Mac You would have to add a query for every file you add to the folder and include a step that appends that particular file to the others. Doable but not very effective.