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,

     

jnixon's avatar
jnixon
Advocate II
6 years ago

Hi,

 

Try selecting first two columns, unpivot other columns, then select Date column and Pivot that one.

 

Make sense?

 

Kind regards,
Jeff