Cannot expand the list values in side the column

[Thakshila]

Hi All,

I have an issue expanding the list values inside the power query. I'm not getting the two small arrows to expand the column as we usually do. any idea how to resolve it?

Thanks 

[KNP]

Right click and choose, To Table...

You'll then be able to work with it.

[Thakshila]

Hi KNP,

That is the problem, When I convert it to the table. Still, I don't get an option to expand columns

Thanks

[wdx223_Daniel · Accepted solution]

NewStep=Table.TransformColumns(PreviousStepName,{"Column1",each if _ is list then _ else {_}})