Results 1 to 3 of 3

List .Combine, versus Expand

Threaded View

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

    List .Combine, versus Expand

    Hi,
    If I needed to get at the values in a list of lists, I've used either List.Combine or Union, but have just found

    Table.ExpandColumnList, my question is are there any advanctages that anyone knows of for using one over the other?

    Combine is a lot easier,

    I've attached workbook showing both and how I've used them

    Table.Group(#"Grouped Rows", {"Tunits"}, {{"Count", each _ }, 
                                                         {"Customers", each List.Combine( [Clist] )  }} )

    = Table.Group(#"Grouped Rows", {"Tunits"}, {{"Count", each _ },
                       {"Expand", each List.Distinct( 
                                                 Table.ExpandListColumn(_, "Clist") [Clist] )   }} )


    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: 06-01-2018, 10:31 AM
  2. [SOLVED] Drop Down List to Show Symbols versus Letters
    By sherylt13 in forum Excel General
    Replies: 4
    Last Post: 08-30-2017, 05:23 AM
  3. [SOLVED] IF versus LOOKUP versus ARRAY?
    By Gtrtim112 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-22-2015, 12:55 AM
  4. [SOLVED] How to expand a list
    By Lehany in forum Excel General
    Replies: 3
    Last Post: 10-02-2014, 12:11 PM
  5. [SOLVED] Need to take a list of names and expand them so the list shows the same name 5 times...
    By 1OneSeven7 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-24-2012, 01:33 PM
  6. [SOLVED] 3,000 Tables versus 3,000 Worksheets versus 3,000 Workbooks
    By StevenM in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-18-2012, 03:15 AM
  7. [SOLVED] XLA versus Reference versus Nothing
    By Jos Vens in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2005, 04:06 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