Hi Philip, sorry I didn't do that. I may have discovered the solution. The code used "Comparer.OrdinalIgnoreCase" I believe. I removed the ignore c...
As a follow up to my last post, I've tried recreating in Excel Power Query with our actual data, and I'm getting the same behaviour as Power BI where ...
Thanks for your response, I totally get what you're saying. Perhaps you'll humour me momentarily with a thought. In the dummy file provided, we're loo...
Hello Catalin, I was looking over your previous code, and I still think this is going to work, but it's providing something just a tiny bit different ...
Thank you, thank you and thank you. You've been a great help.
Thanks for explaining the FilterTable - I was able to get that created as a separate query, without error. I've tried pasting the remaining code a...
The function FilterTable can be moved as an external function, if needed. Any chance you can help be understand that a little better? I'm a littl...
Wow, I think this may work, though I'm having a difficult time trying to understand the add tbl functionality in PQ. I'm trying to get this to work...
Hi again, thanks for your response. While the data does appear to be in pairs, the problem arises when looking at current information - say for exampl...
Thank you for your response. I think that solution more or less does the trick. The problem I'm running into is I have Person A, Person B, etc. I can'...
Thank you both for the help. Can't believe I missed what was staring right at me - Catalin, great suggestion. I can't convert "-" to null or zero, as ...
Mynda, whatnks for your reply. I'm afraid that didn't work. I'm not sure how I can possibly send you an example book as it's entirely made up of worke...