Create Table With Dynamic Heading

[Cheloo]

Happy New Year to all the experts!

Please, I have a question. I want to merge various tables in different worksheets with headings corresponding to dates, but every time I change the date, my query fails. I need help. Thank you, and please find my spreadsheet attached. The idea here is to figure out how to make a query that will allow me to change the heading titles.

Thank you

 

[AlienSx]

let
    Source = Excel.CurrentWorkbook(),
    combine = Table.Combine(Source[Content])
in
    combine

 

[GraH - Guido]

Alternative is to unpivot first and load as a pivot table again.

let
    Source = List.Transform(
                Excel.CurrentWorkbook()[Content],
                each Table.UnpivotOtherColumns(_, {"Client"}, "Date", "Value")
            ),
    Append = Table.Combine(Source),
    Set_Types = Table.TransformColumnTypes(Append,
                {
                    {"Date", type date},
                    {"Value", type number},
                    {"Client", type text}
                }
            )
in
    Set_Types