Concatenate a list in a custom column

[v2]

Hi,

Wondering if you can help. It sounds easy but i am having trouble doing it.

So i have a table with once column as below

Value list

a

b

c

I need to create a new column in the same table and concatenate value list in a new column to read as below:

[a,b,c] . This will be in one cell in the new column.

Thanks for your help.

Regards

V

[v2]

Thanks for your help. it worked.

[Vijay_A_Verma]

Use following

=Text.Combine([Data],",")

Where Data is the name of the column which holds the list

[v2]

Hi Vijay,

Thanks for your promp response.

Unfortunately i am getting an error using your formula. I have 63 items ( this can increase in the future) and i need to combine all these values starting with a square bracket followed by each item followed by a comma and a closing square bracket at the end. i.e. [a,b,c,d,e,f]

Am i getting a error due to the lenght of the string perhaps?

[Vijay_A_Verma]

Can you please post the screenshot of your error?

[v2]

[wdx223_Daniel · Accepted solution]

NewStep=Table.AddColumn(PreviousStepName,"Custom",each "["&Text.Combine(PreviousStepName[sup],",")&"]")