Help with Expanding Tables

[adamplowman]

HI All 

I have followedthis blog post

https://blog.crossjoin.co.uk/2014/05/21/expanding-all-columns-in-a-table-in-power-query/

And i get the following error 

I think this is due to my data having rows that are blank and others as Tables 

Can anyone help tweak this fuction to accomodate "". I dont want to lose the rows of data, just expand where possible etc. 

[AlexisOlson]

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-b...

[Anonymous]

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

[Anonymous]

You need to remove blanks and nulls to expand

[adamplowman]

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