Forum Discussion
Solved
How to Expand two nested table column simultaneously in Power Query
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 expan...
NewStep=Table.Combine(Table.ToList(PreviousStepName,each Table.FromColumns(Table.ToColumns(_{0})&Table.ToColumns(_{1}),Table.ColumnNames(_{0})&Table.ColumnNames(_{1}))))
NewStep=Table.Combine(Table.ToList(PreviousStepName,each Table.FromColumns(Table.ToColumns(_{0})&Table.ToColumns(_{1}),Table.ColumnNames(_{0})&Table.ColumnNames(_{1}))))