Power query nested table

Question

I have xml file that i need to process. My output look like this :

In the nested table there is only one value but i cant figure out how to ungroup them.

Answer 1

Add a column and insert the following M (replacing channel.item.ht with whatever your column name actually is).

if [channel.item.ht] is table then Record.ToList([channel.item.ht]{0}){0} else [channel.item.ht]