Results 1 to 5 of 5

Power Query (Maybe)

Threaded View

tpowell Power Query (Maybe) 01-06-2025, 05:42 PM
TMS Re: Power Query (Maybe) 01-06-2025, 07:42 PM
TMS Re: Power Query (Maybe) 01-06-2025, 07:49 PM
TMS Re: Power Query (Maybe) 01-06-2025, 07:57 PM
TMS Re: Power Query (Maybe) 01-08-2025, 07:11 PM
  1. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,286

    Re: Power Query (Maybe)

    In the absence of a Power Query solution, or any other proposal, let's go "old school":

    Use a Helper Column, say Column M. Then . . .

    Cell: M2
    =IFNA(VLOOKUP(G2,P:R,3,FALSE),G2)
    and copy down to end of data

    Then copy the entire column M.

    Paste Special | Values over column G

    Delete column M
    (and any unrequired data)

    Save as .csv file (recommend saving with a new file name)

    Upload .csv file


    You could, if you wish, record a macro while you go through the steps manually. However, it will need tweaking and it may not be worth the effort.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 10-31-2023, 11:12 AM
  2. Power Query - Feeding dynamic sheet name to Power query
    By egoosen3 in forum Excel General
    Replies: 5
    Last Post: 09-13-2023, 07:41 AM
  3. [SOLVED] [Power Query] How to filter 0 from two columns in power query editor in one step?
    By daliye in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2023, 09:44 PM
  4. Replies: 1
    Last Post: 07-14-2023, 10:15 AM
  5. [SOLVED] Power Query - excel formula translation into Power Query
    By afgi in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-19-2020, 03:38 AM
  6. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  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

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