Power Query General Question

[mduntley]

Is it possible to delete a column, and then after insert it back in? I need to do some formating in a column

 

[RoryA]

Do you mean from the source data, or within your query?

 

[mduntley]

Within my query

 

[RoryA]

I don’t really understand why you would need to do that?

 

[mduntley]

Ok, here is a example. I am trying to get all unique value in column 2. How i am going to do it right now is to create a new table, only have column 2, split them in different rows, remove duplicate, combine them into one cell and then merge them into my original table. I am wondering if there is a easier way to do it.l

let
    Source = #table({"Column1", "Column2", "Column3"}, {{"Fruit","Apple","Market"},{"Fruit","Orange","Store"},{"Fruit","Orange",null},{"Fruit","Banana",null},{"Fruit","Orange",null},{"Fruit","Berries",null}}),
    #"Grouped Rows" = Table.Group(Source, {"Column1"}, {{"Count", each _, type table}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Text.Combine([Count][Column2],"#(lf)")),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom.1", each Text.Combine([Count][Column3],"#(lf)")),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom1",{"Count"})
in
    #"Removed Columns"

This is my table i have right now

Book1
	A	B	C
1	Column1	Custom	Custom.1
2	Fruit	Apple Orange Orange Banana Orange Berries	Market Store
Sheet2

I want to get this

Book1
	A	B	C
1	Column1	Custom	Custom.1
2	Fruit	Apple Orange Banana Berries	Market Store
Sheet2

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    tbl = Table.TransformColumns(Source, {"Custom", each Text.Combine(List.Distinct(Text.Split(_, "#(lf)")), "#(lf)")})
in
    tbl