Forum Discussion
Solved
Power Query: Create column from cell value in table column
Hi everyone, I find myself in a bit of a pickle after trying several options without any success. So here I am with a problem that I sincerely hope someone can help me with. I imported multip...
Create the new column with this
= Table.SelectColumns([Excel.Data], "Column5"){0}[Column5]That code is based on your image which shows each table has 5 columns, the 5th being called Column5, and the data you want being in the first row of that column.
Regards
Phil
Create the new column with this
= Table.SelectColumns([Excel.Data], "Column5"){0}[Column5]
That code is based on your image which shows each table has 5 columns, the 5th being called Column5, and the data you want being in the first row of that column.
Regards
Phil
I love it when the solution end up being something much simpler than whatever I was trying. Thank you so much!