Forum Discussion

Recoba88's avatar
Recoba88
Icon for Helper III rankHelper III
9 years ago
Solved

Make Headers from two different columns (Power Query)

HIi,   I want to make the table below to this table    Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7...   DATA1     DATA2     DATA3   DATA4     DATA5     DATA6      AN...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    Yes, with the following code; replace Source with the name of your previous query step:

     

    = Table.FromRows({Source[Column2]&Source[Column4]},Source[Column1]&Source[Column3])
MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
9 years ago

Yes, with the following code; replace Source with the name of your previous query step:

 

= Table.FromRows({Source[Column2]&Source[Column4]},Source[Column1]&Source[Column3])
  • Recoba88's avatar
    Recoba88
    Icon for Helper III rankHelper III
    9 years ago

    Thanks!

     

    What do you suppose to do in this case ?

     

     

     

     

     

    The code didn't work if I have null "headers" . I tried to create custom column and change null value to some different value like "1" but it didn't work 

    • MarcelBeug's avatar
      MarcelBeug
      Icon for Community Champion rankCommunity Champion
      9 years ago

      Topic this is continued here.

      • Recoba88's avatar
        Recoba88
        Icon for Helper III rankHelper III
        9 years ago

        Hi, it is not.

         

        It is different approach to solve my question.

         

        The question in this topic is how can I use your code for transformation column with null values?