Forum Discussion

Thakshila's avatar
Thakshila
Frequent Visitor
4 years ago
Solved

Cannot expand the list values in side the column

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?     Than...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

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

KNP's avatar
KNP
Super User
4 years ago

Right click and choose, To Table...

You'll then be able to work with it.

 

 

Thakshila's avatar
Thakshila
Frequent Visitor
4 years ago

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's avatar
    wdx223_Daniel
    Community Champion
    4 years ago

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