Add custom column

[JL0101]

When I go to add a custom column in power query the table I want does not show up in the availible list, what would be the cause of that? The one I want is a duplicate of another table if that makes a difference?

I would like to bring in another table as a list in each cell of a row of the new table.

Thanks

[JL0101]

Thanks I will take a look 

[JL0101]

[v-yanjiang-msft · Accepted solution]

Hi @JL0101 ,

By my test, change the single quotes to double quotes will solve the problem.

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.