How to transform title of the data table to column

[gvlado]

Hello
I am still learning and have a simple problem that I couldn't find the solution to.
At the top of the source table there is date i need to incorporate in the report - so how to do it with Power Query in Power BI and Excel

 

Thanks in advance 
Greetings from Croatia

[Anonymous · Accepted solution]

@gvlado Check if this can helps.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WckksSVXSUVKK1YlWMjIwtNA1MNQ1NISJuBWVZpYUA3nO+Tn5RWChxIKCHJCOotQUML8gpzQXyC3LzM9JLQGLJGekFhVVAsWScxKLQGKxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Removed Top Rows" = Table.Skip(Source,2),
    #"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]),
    GetValueFromCell = Source{1} [Column1],
    #"Added Custom" = Table.AddColumn(#"Promoted Headers", "NewColumnName", each GetValueFromCell)
in
    #"Added Custom"

[gvlado]

Thanks , Mohan1029 - it works
Thanks a lot.
I learned something more