Thanks for sharing. Managed to not make any modifications at the source, but loaded the data, fixed some inconsistencies and added some features.
Will test the update at the end of the day.
RemoveBlankRows = Table.SelectRows(PromoteHeaders, each ([ID] <> "")),
RenameColumn =...