Combine Table with Table of Tables

[SebSchoon1]

Hi POwer query superstars,

I have a nice problem for you.

Is it possible to combine a table

Ex:  #"The headers i Need"

With each tables like here below 

In order to get all the headers from 

#"The headers i Need"

into each tables

?

😛

[v-kkf-msft]

Hi @SebSchoon1 ,

I am not sure if I understood your question correctly. If you simply want to merge all tables in this list into one table, please try using the Table.Combine function.

combine = Table.Combine(#"Previous Step Name"[#"All rows"])

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexisOlson]

Do you mean like this:

Table.TransformColumns(
    #"Previous Step Name",
    {{"all rows", each Table.Combine({#"The headers i Need", _}), type table}}
)

If you want you can promote headers in the same step

each Table.PromoteHeaders(Table.Combine({#"The headers i Need", _}))

[SebSchoon1]

Hello, @AlexisOlson Sorry for late reply i was on vacation 👌

I'll try this asap and keep you posted!

So many thanks for your reply!

[SebSchoon1]

I have been able to manage it creating a function. Then

= Table.Combine(Table.AddColumn(#"Colonnes supprimées1", "Personnalisé", each Fusion_entetes_groupes([all rows])))

However this is extremely slow. 

any advice?