Hi khalidmajeed, you can only merge two tables at a time in Power Query. For example if you have 3 tables, you could merge the first two tables and create a new table, the new table would be "Merge1" then use "Merge1" and merge it to your third table. The other option is to use Power Pivot.
Hi again, I can actually do this easily by following exact sample and scenario in your sample video. However, is it possible if I am working on a query and I wanted to do the vlookup the code from other source or other sheet? I was trying to do it by I failed. I am trying to find videos related to my query actually but so far yours is the closes one. Is there any possibility also to merge multiple Lists (more than 2)? because I want to do a vlookup not just from 1 list but also for other category list.
Hi @Jhan Michael, you can only merge two tables at a time in Power Query. For example if you have 3 tables, you could merge the first two tables and create a new table, the new table would be "Merge1" then use "Merge1" and merge it to your third table. The other option is to use Power Pivot.
@@MissMicrosoft hi, yes somewhat I was able to manage it. It is really difficult to do trial and error if I am learning all by myself. I saw one of your video also on how to add macro/ Refresh Button. It was awesome. I am now using it. But, could you also create another video on how to generate an output file using macro after you got the result from power query?
Very nice! Useful tips and well explained. Thanks for sharing your knowledge! Thumbs up!! PS - Some presenters share the example file to make it easier to follow along. I find it very helpful. Just an idea for your future videos. Cheers :))
Wow ! this is awesome 👍👍👍
Thank you so much 😊
Thanks! Great explanation…
You're most welcome Ronnie :)
Thanks👍
Great
Glad you enjoyed it Faisal :)
how to use in multiple tables
Hi khalidmajeed, you can only merge two tables at a time in Power Query. For example if you have 3 tables, you could merge the first two tables and create a new table, the new table would be "Merge1" then use "Merge1" and merge it to your third table. The other option is to use Power Pivot.
Hi again, I can actually do this easily by following exact sample and scenario in your sample video. However, is it possible if I am working on a query and I wanted to do the vlookup the code from other source or other sheet? I was trying to do it by I failed. I am trying to find videos related to my query actually but so far yours is the closes one. Is there any possibility also to merge multiple Lists (more than 2)? because I want to do a vlookup not just from 1 list but also for other category list.
Hi @Jhan Michael, you can only merge two tables at a time in Power Query. For example if you have 3 tables, you could merge the first two tables and create a new table, the new table would be "Merge1" then use "Merge1" and merge it to your third table. The other option is to use Power Pivot.
@@MissMicrosoft hi, yes somewhat I was able to manage it. It is really difficult to do trial and error if I am learning all by myself. I saw one of your video also on how to add macro/ Refresh Button. It was awesome. I am now using it. But, could you also create another video on how to generate an output file using macro after you got the result from power query?
👍👍👍
Thank you :)
Very nice! Useful tips and well explained. Thanks for sharing your knowledge! Thumbs up!! PS - Some presenters share the example file to make it easier to follow along. I find it very helpful. Just an idea for your future videos. Cheers :))
Glad it was useful Wayne! I will definitely work on sharing the example file for future videos, thanks!