Results 1 to 2 of 2

I need to delete specific rows based on specific country through Power Query.

Threaded View

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

    Post I need to delete specific rows based on specific country through Power Query.

    Hi,
    I have attached excel file, in that file I have table 1 (SALES) and table 2 (COUNTRY AR).
    In TABLE 3 (RESULT) , I need only those values from table 1 for Country AR which are present in Table 2 and except AR all values should appear as you can see in RESULT table. ( in Excel Table 1, yellow highlighted cells should be excluded as it is not available in table 2).

    I need this solution in power query please help me.
    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. Using Power Query to extract specific data
    By JasonWier in forum Excel General
    Replies: 1
    Last Post: 09-21-2021, 11:00 AM
  2. Power Query - Transpose Specific Columns
    By keith6292 in forum Excel General
    Replies: 1
    Last Post: 07-20-2021, 04:01 PM
  3. Power query import based on specific row
    By garyb123 in forum Excel General
    Replies: 6
    Last Post: 05-18-2021, 01:19 PM
  4. [SOLVED] Get data from specific website using power query
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2021, 03:08 AM
  5. 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
  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. How to find specific work and delete next two rows also select range with specific words
    By priyadharshane in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2019, 03:08 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