Ok, this may seem like an odd question - so hear me out please.
Currently, we work within an Government client environment which has heavy restrictions on what we can and can't use, or do. Macros are a no go, but mercifully Power Query is ok.
The business problem that drives me up the wall is...