Add Custom Concatenate Row

[ryan_b_fiting]

Hello Community - 

I am looking to add a custom row to my table in Power Query.  Currently there are 2 seperate 'header rows' and I want to concatenate them into a single row.  The rows come like this from the source data so I want to be able to combine them in the query to avoid any manual intervention.

I need to combine them, because one of the rows contains the fact value and the other contains a date that I need to be able to use.  See screen shot below.  

How am I able to concatenate these so I can promote them to the headers before I unpivot my data and do the other transforming that needs to be done?

Thanks for the help!

Ryan F

[Mariusz · Accepted solution]

Hi @ryan_b_fiting 

Please see the attached file with an example.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[ryan_b_fiting]

@Mariuszthis is just what I needed.  Very simple.  Thank You!