Convert power query table to a single line list

[Anonymous]

Hi,
I have a table in power query that I want to convert into a SINGLE line list so I can use it as a parameter.  I want to use the parameter in an "in" clause in a SQL statement.

Here is the example table

Table
Cow
Chicken
Dog
Cat
Bird

Desired Single line list
'Cow','Chicken','Dog','Cat','Bird'

[Anonymous]

Hi again, I think I found the menu item to convert it

[Anonymous]

Hi Ahmedx,

Thanks for the detailed instructions. I was able to follow them through. The only issue is that the result is a string, not a list. I am unable to create a parameter from the result. Do you know how to convert the string to a single-line list? All of the transformation options are grayed out for the result. 

[Ahmedx · Accepted solution]

pls see my video
https://1drv.ms/v/s!AiUZ0Ws7G26RiAM5vdvvIh8nFqPw?e=8tth7V

Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RiAIx2m_UnXzIz_Ls?e=HGWMj2

(x) => "'" & Text.Combine(x, "','") & "'"