Ok Guys, maybe will be useful for you, i solved the issue (with help from outside) AllFiles - first query: let Source = Folder.Files("C:Use...
Hmm this is idea! But few questions still: 1) i see that power query sees named ranges and not seeing tables: So still retriving tabl...
Thanks. It is not possible to query named ranges? And combining tables is only for whole worksheet, not exact range where table is? How can i...
Thank you. So in this function just filtering table to get specific row? I have to get just an exact value , not list ? Best Wishes, Jacek
Sorry, this is not helpful. i am merging multiple workbooks together and want to get exactly what i wrote. What power query will be for this? ...
Thank you Catalin! Have a blessed day! Jacek
thank you, let me check Best wishes, Jacek
I do not think so it is possible without having copy of table. Best, Jacek
Generally with VBA i could create a copy of table somewhere and check differences. But it is possible within Power Query only? Just create tempora...