Results 1 to 8 of 8

How to delete rows on Different criteria in Power Query

Threaded View

  1. #1
    Registered User
    Join Date
    11-02-2022
    Location
    Pakistan
    MS-Off Ver
    Office 365
    Posts
    10

    Question How to delete rows on Different criteria in Power Query

    Hi everyone,
    I have three columns to in Excel file and I want the solution in Power Query.
    Here are the complete details:

    Column A Column B
    U UU
    U SIT
    U QI
    Z SIT
    V SIT
    V QI
    V UU
    Z2 SIT
    Z UU
    Z QI
    Z SIT
    Z2 QI
    Z QI
    Z2 SIT
    Z2 SIT
    Z QI
    Z2 SIT


    I need to remove only specific rows where Column A contains Z and Z2 and column B contains QI and UU.
    In other words I just want to keep all vaue for column A except for Z and Z2 I need only SIT value in column B. Please help me to solve this issue in Power Query.

    Thanks,
    Rose
    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. [SOLVED] Delete null cells in Power query
    By Undo in forum Excel General
    Replies: 9
    Last Post: 06-19-2022, 02:01 PM
  2. Replies: 1
    Last Post: 11-14-2021, 01:06 PM
  3. Replies: 1
    Last Post: 05-07-2021, 05:40 AM
  4. Extract specific rows based on criteria in power query
    By ronakchoudhary in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-31-2020, 05:02 PM
  5. [SOLVED] Power query header row delete
    By pdig in forum Excel General
    Replies: 3
    Last Post: 03-22-2019, 05:51 AM
  6. Power Query - Remove Specific Duplicate Rows (Based on sort criteria)
    By kersplash in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-22-2019, 03:30 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