Forum Discussion

phaum1967's avatar
phaum1967
Resolver I
8 years ago
Solved

Unpivot header

Hi everyone, I have serveral csv files that I want to transform. I want to create a function but I m unable to define how I can Unpivot all my files: The first row contains period of time fr...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Perhaps try this for your Promoted Headers:

     

    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Perhaps try this for your Promoted Headers:

 

#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),