How to Expand two nested table column simultaneously in Power Query

[Yaseen_Muhammad]

Hi community expert, while struggling from 2-3 days how to expand two columns simultaneously containing nested table. any help will be appreciated. Attached are screenshot have table. I want to expand both columns same time to avoid duplication in data set.

 

[Yaseen_Muhammad]

Hi, the Solution work perfectly. if i get the code in piece wise I will learn a bit more. Thank you soo much.

[wdx223_Daniel · Accepted solution]

NewStep=Table.Combine(Table.ToList(PreviousStepName,each Table.FromColumns(Table.ToColumns(_{0})&Table.ToColumns(_{1}),Table.ColumnNames(_{0})&Table.ColumnNames(_{1}))))