Forum Discussion
Extract List to new Column
Just leave code part. I think Extract values part will be very easy for you (it will generated required code automatically)
click the doubled edge arrow and Extract values.
Choose custom and then select Concatenate using special characters - Insert Special Characters - Select Line Feed - OK
That is what I had done...You need to insert this statement in your code where you need to replace #"Added Custom" with previous step.
To do this, right click on last step of your query - Insert step after (now in formula bar, it would show your previous step which you should copy) and paste the below one into Formula bar and replace #"Added Custom" with your previous step
= Table.TransformColumns(#"Added Custom", {"Choices", each Text.Combine(List.Transform(_, Text.From), "#(lf)"), type text})Now, if you are not able to do so, then click the doubled edge arrow and Extract values.
Choose custom and then select Concatenate using special characters - Insert Special Characters - Select Line Feed - OK
Sorry you lost me there, can you post the full code?
Just leave code part. I think Extract values part will be very easy for you (it will generated required code automatically)
click the doubled edge arrow and Extract values.
Choose custom and then select Concatenate using special characters - Insert Special Characters - Select Line Feed - OK
thats the one! Sorry we got there in the end! Many thanks