Appending data using power query

ajl_ahmed That's not going to be easy or very efficient, I'm afraid. And it goes beyond the scope of my involvement in this forum to build something like this from scratch. And without any knowledge of PQ it would be difficult for you to follow. Perhaps you can learn the PQ basics first, though that's not so easy either as all the tutorials on line are written for PQ on a PC and the look and feel on the Mac is not quite the same. At least, that's my opinion.