How do I convert a list to one field?

[Netrelemo]

The source is one column: 

A

B

C

D

...

And I want to have 

A; B; C; D; ...etc..     all on one line, in one field.

A sort of grouping. 

[Jihwan_Kim · Accepted solution]

Hi, @Netrelemo 

Please check the below for creating a one-row table.

https://www.dropbox.com/s/7yt5szjfmlqzgli/netre.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[parry2k]

@Netrelemo one more thing, if it is already a list column then do this:

Lines.ToText([List Column Name],";")

[parry2k]

@Netrelemo with PQ you can add a new column:

Lines.ToText(#"Previous Step"[ColumnName],";")

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[mahoneypat]

Here's one way to do it in the query editor.  To see how it works, just create a blank query, open the Advanced Editor and replace the text there with the M code below.

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclSK1YlWcgKTzmDSRSk2FgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
Custom1 = Text.Combine(Source[Column1], ";"),
#"Converted to Table" = #table(1, {{Custom1}}),
#"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type text}})
in
#"Changed Type"

Pat