+ Reply to Thread
Results 1 to 8 of 8

Power Query - Expanded a Columns

  1. #1
    Forum Contributor
    Join Date
    07-10-2020
    Location
    New Zealand
    MS-Off Ver
    365 personal
    Posts
    295

    Power Query - Expanded a Columns

    Hi
    In Book two I am importing from workbook BB that sits in a Folder. When I expand the columns there are more columns than can be displayed in eth Dialog Box. If I was using teh UI I would choose Load More. I have used Table.Combine to ensure all columns are expanded. However, I get an error in one of eth columns.

    How do I fix this?

    Thank You

    Allister
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Power Query - Expanded a Columns

    could you explain what this mean in you last step?
    Please Login or Register  to view this content.

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Power Query - Expanded a Columns

    What is your Text.Contains function supposed to be doing?
    Rory

  4. #4
    Forum Contributor
    Join Date
    07-10-2020
    Location
    New Zealand
    MS-Off Ver
    365 personal
    Posts
    295

    Re: Power Query - Expanded a Columns

    Should be Table.Combine (but this does not fix the issue).
    But I am trying to combine all 30 cols instead of just the first 14 cols that show in the UI
    Last edited by AllisterB; 10-27-2022 at 04:31 AM.

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Power Query - Expanded a Columns

    You don't have Table.Combine in there anywhere. You used Text.Contains which doesn't make a lot of sense.

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Power Query - Expanded a Columns

    ... and there is 35 columns not 30

  7. #7
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Power Query - Expanded a Columns

    Click on "Load More" which appear right side bottom
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  8. #8
    Forum Contributor
    Join Date
    07-10-2020
    Location
    New Zealand
    MS-Off Ver
    365 personal
    Posts
    295

    Re: Power Query - Expanded a Columns

    Apologies... I am tired and didn't see I used Text.Contains instaed of Table.Combine - all good now

+ 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. Unpivot Columns without Power Query
    By dluhut in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-30-2022, 06:38 AM
  2. [SOLVED] Power query naming columns
    By Dicken in forum Office 365
    Replies: 12
    Last Post: 09-02-2022, 01:15 PM
  3. Adding columns to power query
    By JyothiGrace in forum Excel General
    Replies: 4
    Last Post: 01-26-2021, 02:11 AM
  4. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  5. [SOLVED] Power Query - update particular columns
    By afgi in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 02-16-2020, 06:41 PM
  6. Custom Permutations Column in Power Query from two columns in the same Query
    By PaintPaddy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2019, 02:48 PM
  7. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM

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