Getting complete power over your documents at any time is important to relieve your daily duties and boost your efficiency. Accomplish any goal with DocHub tools for document management and convenient PDF editing. Access, adjust and save and incorporate your workflows with other protected cloud storage.
DocHub gives you lossless editing, the opportunity to use any formatting, and securely eSign documents without the need of searching for a third-party eSignature alternative. Get the most from the document managing solutions in one place. Check out all DocHub functions right now with your free of charge 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