Help with Expanding Tables

Question

HI All&nbsp;I have followedthis blog post&nbsp;https://blog.crossjoin.co.uk/2014/05/21/expanding-all-columns-in-a-table-in-power-query/&nbsp;And i get the following error&nbsp;I think this is due to my data having rows that are blank and others as Tables&nbsp;&nbsp;Can anyone help tweak this fuction to accomodate "". I dont want to lose the rows of data, just expand where possible etc.&nbsp;

anonymous · Answer

You need to remove blanks and nulls to expand

adamplowman · Answer

but if i remove them i will remove the rows completely. Which i dont want todo. Is there a way to dynamically expand?

anonymous · Answer

You can add this column as a new query and expand it then just merge again with previous table.

alexisolson · Answer

This prior thread includes multiple approaches to solving this:
https://community.powerbi.com/t5/Power-Query/Expanding-items-in-List-in-column-when-some-cells-are-blank/m-p/2196631

Forum Discussion

Help with Expanding Tables

4 Replies

Related content

expanded table

Expanded table

Expanded table

Dynamically Expand Table Records

Expand Table