Transfer a column of a table into a list

[Nick001]

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 in the data model. Then i would like to create another new table from the list 

Many Thanks Nick

[Nick001]

wow, thank you very much 🙂 I've tried so much and then it's so easy - thank you

Nick

[Anonymous · Accepted solution]

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