Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data transormation

Hi all, Need some tips and explanation about how to do this. I'm extracting data from several excel sheets (and multiple workbooks) :          When i expand this column, i get someth...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    We can try to add a custom column:

     

    Table.PromoteHeaders(Table.Transpose([NameOfYourSecondColumn]), [PromoteAllScalars=true])

     

    Then delete the old column and expand the new table column to meet your requirement.

     


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

We can try to add a custom column:

 

Table.PromoteHeaders(Table.Transpose([NameOfYourSecondColumn]), [PromoteAllScalars=true])

 

Then delete the old column and expand the new table column to meet your requirement.

 


Best regards,