Editing ODM is fast and simple using DocHub. Skip installing software to your PC and make adjustments with our drag and drop document editor in just a few easy steps. DocHub is more than just a PDF editor. Users praise it for its convenience and robust capabilities that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and email records for completion to other people. All of this, put together with a competing cost, makes DocHub the ideal choice to clean up header in ODM files with ease.
Make your next tasks even easier by turning your documents into reusable web 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
