Dynamically expand table or record columns in Power Query
In this article, we will show how to solve a common problem of expanding nested tables or records in Power Query, when the column names of the nested objects vary in numbers. In the second part of the article, we will show a more robust technique for dealing with changing structures of the nested tables. …
Dynamically expand table or record columns in Power Query Read More »
