Getting comprehensive power over your files at any time is important to relieve your everyday tasks and improve your productivity. Accomplish any goal with DocHub features for document management and practical PDF editing. Access, change and save and incorporate your workflows with other protected cloud storage services.
DocHub gives you lossless editing, the opportunity to use any format, and safely eSign documents without the need of looking for a third-party eSignature software. Obtain the most of your file managing solutions in one place. Check out all DocHub capabilities right now with the free profile.
hello and welcome to the video by Trump Excel I am so mad Bunsen and in this video I will show you how to extract data from one table and put it in another table using power query so here I have this data and I have these items printer whiteboard office chair diary projector here and what I want to do is allow the user to select an item from the drop-down and then based on the selection extract the relevant records here in this area or you can have it in the new worksheet so to do that I first need a list of these items now you can easily create a list of these items if you have it anywhere you can use that over you can use power query to do that so in this case I would go to data from table range and here I would select this one remove every other column and remove the duplicates from here so that it gives me a list of unique items here and now I would come here close and load - and I would load it in a new worksheet so when I click OK it inserts a new sheet here and I have these ite
