+ Reply to Thread
Results 1 to 2 of 2

Power Query Grouped table column names

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

    Power Query Grouped table column names

    Hi is there a way to access grouped 'all row' table column names when new columns have been added;

    So here I have grouped , added a new column and then removed the group by column , I now would like to use table expand table col

    Please Login or Register  to view this content.

    But I need the column names from within the group, I did make it ia list of tables and then combine which does not require names,
    and also ReocrdFieldValues as below, which does work, but is

    Please Login or Register  to view this content.
    But is there a simpler / neater way of doing this, I have attached a workbook with the above examples,

    Richard.
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Power Query Grouped table column names

    I don't really see the need for half of what you have in there, but you could use something like:

    Please Login or Register  to view this content.
    Rory

+ 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: 0
    Last Post: 07-06-2023, 11:27 AM
  2. [SOLVED] Power Query - Custom column populating using worksheet names
    By Exodian in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-16-2023, 08:30 PM
  3. Power Query Sum within grouped data
    By Dicken in forum Office 365
    Replies: 5
    Last Post: 02-20-2023, 08:32 AM
  4. Power Query Grouped Running Total
    By sle7en in forum Excel General
    Replies: 2
    Last Post: 02-13-2021, 06:30 PM
  5. Power Query - column names with brackets
    By afgi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-07-2020, 07:55 AM
  6. [SOLVED] Power query change column names
    By Steveapa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2020, 04:45 PM
  7. Replies: 2
    Last Post: 02-13-2019, 07:39 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