Generating custom List

[smpa01]

My datasource is following

let
    Source = {[r1=1,r2=2],[r1=3,r2=4],[r1=4,r2=5]}
in
    Source

How can I end up with a seperate custom list only for r1 or r2  from the above Source

e.g.

r1 = {1,3,4}

r2= {2,4,5}

I tried following and it did not work

Let

Source = as above,

r1= List.Generate(

()=> [i=0, j=Source{i}[r1]],

each [i] < List.Count(Source),

each [i=[i]+1, j=Source{i}[r1]],

each [j]

)

in r1

[Anonymous · Accepted solution]

Hi @smpa01 

Maybe you can work from here, not very generic, just for your sample data

let
    Source = {[r1=1,r2=2],[r1=3,r2=4],[r1=4,r2=5]},
    Custom1 = [r1=List.Transform( Source, each Record.Field(_,"r1")),
r2= List.Transform( Source, each Record.Field(_,"r2"))]
in
    Custom1