A creative and innovative Business Analyst and VBA Developer, with a proven track record of success in various industries including construction, automotive, and telecommunications. Exceptional problem-solving skills, ability to constructively challenge and influence others.
๐จ๏ธ "Adept at taking user requirements (usually vague verbal/email requests) and responding with astutely accurate deliverables. And he delivers quickly to bootโ โ Former Project Manager
๐จ๏ธ โYou leave behind a legacy you can be proud of and that will have a lasting impact on the careers of all who learned from you.โ โ Former Team Leader
Moving a column or multiple columns to the beginning of a table in Power Query can create a lot of extra M code if the table contains a large amount of columns. This custom function reduces that possibility and keeps the M code to a minimum
If you have ever tried to create a two-column table that contains all possible combinations of two ranges of values in Excel, you might have encountered a variety of struggles. You may have used nested loops, helper columns, array formulas, or even VBA macros to achieve this task. However, these methods can be cumbersome, inefficient, or error-prone, especially if you have large or dynamic ranges.