Editing VIA is fast and straightforward using DocHub. Skip installing software to your laptop or computer and make alterations with our drag and drop document editor in just a few quick steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and powerful features that you can use on desktop and mobile devices. You can annotate documents, make fillable forms, use eSignatures, and send documents for completion to other people. All of this, combined with a competing cost, makes DocHub the ideal choice to clean up heading in VIA files with ease.
Make your next tasks even easier by turning your documents into reusable templates. Don't worry about the safety of your information, as we securely keep them in the DocHub cloud.
In this video we are going to look at this bad unclean data which is essentially a complex cross tab with multiple headers on both sides and clean it up using Power Query. What does clean up mean? Well I am sure you have already seen my videos which talk about 10 checklist items. So you look at your data, look at each column and ask yourself does it have a heading? No blank headings, no duplicate headings, no merge sales, no formulas. That is good. And then below the heading in that column there should be data which is consistent and that data should have one meaning, not 2 meanings and if it is dates, all dates, numbers, all numbers like that. Of course this is input data, so we do not need any summary or subtotals or grand totals. Formatting in the raw data is completely useless because nobody wants to look at the raw data. We use the raw data to create a report which is generally summarized and aggregated and that can have all the formatting you want. And one of the most common prop