Does Excel Power Query keep crashing with Error 0xC000026F? It occurs due to compatibility issues between Power Query engine ...
AGGREGATE was built to handle messy data from the start.