Make Headers from two different columns (Power Query)

[Recoba88]

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?

[MarcelBeug · Accepted solution]

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]

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]

Topic this is continued here.

[Recoba88]

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?