Getting comprehensive control of your documents at any moment is vital to relieve your day-to-day tasks and enhance your efficiency. Achieve any goal with DocHub tools for papers management and hassle-free PDF file editing. Gain access, change and save and incorporate your workflows with other protected cloud storage services.
DocHub provides you with lossless editing, the opportunity to use any formatting, and safely eSign papers without the need of looking for a third-party eSignature option. Get the most of your file management solutions in one place. Check out all DocHub features right now with the free of charge account.
someone has published on Facebook on the channel Excel trick a very interesting situation where you have here in the first color on one two four six and so on and couldnt be two three four or five okay and what he expected the end its to match each color but so when you have nothing you just put a dash but also for instance there is no seven in both garden and here you have - so how is it possible to solve this well my solution is to use power query and as you can see here in this workbook I have first color on exactly the same value current - exactly the same and my result its exactly what the guy want and I show you how I did that I restart from scratch so okay here is my data and this data are not yet in tables and its very important when you work with poor query to load this data in table so how do you do that insert table my table has either yes and the second one its exactly the same insert table and I just change a color to visualize that its two different tables perfect