Having full control over your files at any moment is vital to ease your daily tasks and improve your productivity. Achieve any goal with DocHub features for papers management and hassle-free PDF editing. Access, adjust and save and incorporate your workflows along with other safe cloud storage.
DocHub gives you lossless editing, the possibility to use any formatting, and securely eSign documents without searching for a third-party eSignature option. Make the most of the document managing solutions in one place. Consider all DocHub features today 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
