Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Combine each item in list of lists
10-28-2021
09:20 AM
My source data is following
= {{"A","B"},{"C","D"},{"X","Y","Z"}}
From there, I want to land up here
I can do this by doing following
let
Source = {{"A","B"},{"C","D"},{"X","Y","Z"}},
Loop = List.Generate(
()=>[i=0,j=Source{i},k=Text.Combine(j,",")],
each [i]<List.Count(Source),
each [i=[i]+1,j=Source{i},k=Text.Combine(j,",")],
each [k]
)
in
Loop
Is there any other way to achieve the end goal other than using List.Generate? maybe by using List.Transform?
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Visual Capitalist: Working Hrs
Others:Easing Graph, Animated Calendar
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2021
11:13 AM

let
Source = {{"A","B"},{"C","D"},{"X","Y","Z"}},
combo = List.Transform(Source, each Text.Combine(_,","))
in
combo
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2021
11:13 AM

let
Source = {{"A","B"},{"C","D"},{"X","Y","Z"}},
combo = List.Transform(Source, each Text.Combine(_,","))
in
combo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2021
12:04 PM

@ronrsnfld many thanks. This is awesome !!! appreciate the help.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Visual Capitalist: Working Hrs
Others:Easing Graph, Animated Calendar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2021
06:51 PM

Glad to help. Learning PQ has been a fun experience for me.

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
03-10-2025 12:32 PM | |||
Anonymous
| 08-20-2024 05:38 PM | ||
12-29-2024 11:02 AM | |||
12-13-2024 08:54 PM | |||
01-21-2025 10:19 AM |