Create a table with a join one-to-many from Query editor table

HI gpiero,

If you share some detailed information about these table structures it will be help for analysis.

For your scenario, I think you can use power query to get the specify table and use 'Table.Join' function to merge these tables.

Formula: get specify cell value.

Table1= #"Previous Steps Name"[ColumnName]{RowIndex-1}

Sample:

Table1= #"Changed Type"[Utenti]{0}

Full query:

let
    Source = xxxxxxxx,
    #"Changed Type" = xxxxxxx,
    Table1= #"Changed Type"[Utenti]{0},
    Table2= #"Changed Type"[Utenti]{1},
    MergeTable=Table.Join(Table1,"User",Table2,"User")
in
    MergeTable

Reference link:

Table.Join

Regards,

Xiaoxin Sheng