In the attached is a Power Query solution (2 actually)
On Sheet2, there's table at cell G9, and another at cell K9. Right-click one of them and choose Refresh to update it.
They are the same, only one of them has all the steps in one query and the other uses multiple queries to get there.
I've added a test row to each source table for testing.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote
