Cleaning up an accounts file with Power Query

One of the most common tasks faced by accountants and office workers is that of data cleansing i.e. removing the extra blank columns , sub totals, blank rows so beloved of accounts packages but which all need to be removed before any sort of Excel analysis can be done...