Forum Discussion
Solved
Transfer a column of a table into a list
Hi, everyone, I am looking for a solution to the following problem: How can I convert a column of a table into a list without destroying the base table? The base table should continue to exist i...
Let's say your base table is named "BaseTable". You can add a blank query, and then in the formula bar, type:
= BaseTable[ColumnName]
That gives you the list. You can wrap it in Table.Distinct to get unique values. If you want it as a one column table, it's:
BaseTable[[ColumnName]]
--Nate
Let's say your base table is named "BaseTable". You can add a blank query, and then in the formula bar, type:
= BaseTable[ColumnName]
That gives you the list. You can wrap it in Table.Distinct to get unique values. If you want it as a one column table, it's:
BaseTable[[ColumnName]]
--Nate