Forum Discussion

Recoba88's avatar
Recoba88
Helper 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 

 

 

ANY IDEA HOW?

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])

4 Replies

  • MarcelBeug's avatar
    MarcelBeug
    Community 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
      Helper 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