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 {_}})

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
Icon for Community Champion rankCommunity Champion
4 years ago

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