How to transpose and promote headers for all tables in one shot?

[Anonymous]

How to transpose and promote headers for all tables in one shot?

I have 10 tables ( Note here table are queries in PowerBi)

Each table has 1 column and I would like to transpose and promote headers for all the tables .

I have Advanced editor with the below , I want to apply this to all my tables ( table1 ...table10)

let
Source = Sql.Databases("SQLEXPRESS01"),
CDA = Source{[Name="CDA"]}[Data],
dbo_table1 = CDA{[Schema="dbo",Item="table1"]}[Data],
#"Transposed Table" = Table.Transpose(dbo_table1),
#"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true]),

in
#"Promoted Headers"

[ImkeF · Accepted solution]

That's not  possible, I'm afraid.

[amitchandak]

@Anonymous , do you want to merge these tables? if yes you can merge and then transpose.

we can check with M experts on community

@ImkeF , can you help with this

[Anonymous]

No , I dont want to merge as I want to keep each table separate as I will be using them for modeling .

I dont like to repeat manual steps of transpose and promote for 10 tables as it is time consuming .