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
Hi,
Based on the description, the method PhilipTreacy provided should be helpful.
You can also view the following document to learn more information.
Operators - PowerQuery M | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.