Results 1 to 1 of 1

Power Query List of lists to table of tables

Threaded View

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

    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

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