Hi,
I've been trying to change a list of lists to a table of of tables, I have tried
l have managed to get a list of tables ;
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Custom1 = let alist = List.InsertRange( Source [Units], 0, {null} ),
blist = Source [Units],
zipped = List.Zip( {blist, alist } )
in List.Transform( zipped, each Table.FromRows( {_} ) )
in
Custom1
But if I first convert to a tabe of lists I get stuck,
Table.TransformColumns( Custom2, { "List", (B)=> List.Transform(B, (C)=>
Table.FromList(C, Splitter.SplitByNothing(), {"List"} )) } )
OR
Table.FromRows( C ) ) } )
So I'm struck with trying to change a table of lists to a table of mini tables ; just to add I'm not saying this of any use I've just been practicing.
Thee examples attached.
Richard.
Bookmarks