here is the way for
example:
View attachment 22082Power Query:let Source = Excel.CurrentWorkbook(), Expand = Table.ExpandTableColumn(Source, "Content", {"Week 1", "Week 2", "Week 3", "Year", "Month", "Day"}, {"Week 1", "Week 2", "Week 3", "Year", "Month", "Day"}), Filter = Table.SelectRows(Expand, each not Text.Contains([Name], "Query")) in Filter
and so on...
My Excel is OFFICE 360read post#6
I assumed
- all tables are Excel Tables, not ranges that pretend to be tables
- there is nothing more than these tables
btw. you didn't update your profile about Excel version, can you do that?
365 rather ok, but do that in your profileMy Excel is OFFICE 360
post an example of your table (with generic dataActually, all table from online data, unfortunately, the result is shown below, only number, not other details....
let
Source = Excel.CurrentWorkbook()
in
Source
Same result like above...I upload image in Power Query, only first table is shown, second table is "null".