Split multivalue cells from different columns in rows

[paragp]

Need help transforming this: to:

[v-juanli-msft · Accepted solution]

Hi @paragp 

I have two methods, please download my pbix to find more details.

Method 1:

Split "Person Id","Name","Salary",

Then create three queries (Query1, Query2,Query3) to select columns from table ablove,

Append three queries into a new query

Method2:

Please open Advanced editor and click on steps on "APPLIED STEPS" pane to find more details.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.