+ Reply to Thread
Results 1 to 1 of 1

Power Query List of lists to table of tables

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    775

    Power Query List of lists to table of tables

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-08-2024, 09:57 PM
  2. Replies: 1
    Last Post: 08-03-2023, 09:26 AM
  3. [SOLVED] Power Query custom function variable to make table a list
    By Dicken in forum Office 365
    Replies: 10
    Last Post: 07-08-2023, 11:13 AM
  4. [SOLVED] Power query convert list of list to list of tables
    By Dicken in forum Office 365
    Replies: 3
    Last Post: 06-13-2023, 03:16 PM
  5. [SOLVED] Power Query List Transform on Zipped lists
    By Dicken in forum Office 365
    Replies: 3
    Last Post: 05-12-2023, 02:46 PM
  6. Power Query: Updating a query based on changing tables
    By cheesehead101 in forum Excel General
    Replies: 1
    Last Post: 12-16-2019, 06:54 PM
  7. How do I return a value from another table that appears as a list item in Power Query?
    By sexcelhelp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2019, 10:55 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1