A map, a code editor, and a folder full of reports don't have much in common. But they've all become part of my Excel ...

Two suppliers can describe the same kinds of fields with different column names. Simply appending their files can leave ...

Power Query can do quite a lot with just clicks. However, when it comes to slightly complex column splitting or merging, ...