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?

 

 

Thanks 

Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

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

3 Replies

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