Forum Discussion
Filling in a Table with Intermittent Dates
Thanks for your help, here are 2 months of different electrical system use. These have not been cleaned at all, and are as I would receive them from our contractor.
Main issue here is with source files - most probably they generated automatically and not very correctly. In any case Power Query never ends the process if use them as it is.
I cleaned them manually - on each sheet with data go to last row (Ctrl+Down), select next row, select till end (Ctrl+Shift+Down), Home->Clear->Clear All, save the file. Size of the files will be significantly less.
Here are such file and master one which generates summary file. Raw files are to placed in some folder, it's name shall be defined in parameter sheet of Master file (this file shall be kept separately). After that Data->Refresh All.
Some things are hardcoded within power query, please check first if that works as needed, after that we may add some cosmetic.