Forum Discussion
PowerQuery in Excel - adding columns based on a List.
Hi all, I have a question. So Let say I have Table with any data, then I have a list with Columns I wish to add: {"NewCol1", "NewCol2", "NewCol3"} the list is manualy verified ( what ccan y...
wdx223_Daniel
Community Champion
Community Championthis code will add three null columns
=Table.SelectColumns(MyTable,Table.ColumnNames(MyTable)&{"NewCol1", "NewCol2", "NewCol3"},2)