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
I can convert the list to a table but that then over writes all of the data in the query and only the table is viewable. I could duplicate it then create the table but then the relationships are lost. So if the Dropdown Column list can be converted into a new column that is the best solution.
So when you have a list containing {"a","b","c"} and when you extract it to a column, it comes as a,b,c in a single column. You need not split it.
But I think I am not able to understand the exact problem. If you can tell me by taking an example of a list and what output do you need, I will be able to help out.
When I do the extract the column is updated to reflect:
Choice 2Choice3
I need the column to show
Choice 2
Choice 3
When extracting select Extract to Rows.
That will work but the problem then is that then introduces rows with duplicate content, how can I get the data all within the same row?