Forum Discussion

KJeffery's avatar
KJeffery
Frequent Visitor
5 years ago

Combining a column into one single cell

This is a wierd one and there is a peverse logic behind this as i am wanting to use the result in another query.  I am basically trying to get a whole column of data to combine into a single cell.  T...
Need Help
Jakinta's avatar
Jakinta
Solution Sage
5 years ago

 

let
    Source = Table.FromColumns({{1..10}}, {"Column1"} ),
    #"Added Custom" = Table.SelectColumns( Table.AddColumn(Source, "Custom", each Text.Combine( List.Transform(Source[Column1], Text.From) , ", ")), "Custom" )
in
    #"Added Custom"

 

KJeffery's avatar
KJeffery
Frequent Visitor
5 years ago

Thanks unfortunately this didn't work or i don't understand well enough.  I know the "1..10" is creating a list from 1 to 10 however when i use this with my list i only get a one line result.