+ Reply to Thread
Results 1 to 3 of 3

Extract data from cells above from Power query output

Hybrid View

  1. 12-22-2021, 04:17 AM #1
    tiger99
    tiger99 is offline
    Registered User
    Join Date
    01-27-2014
    Location
    Brisbane
    MS-Off Ver
    Excel for Office 365
    Posts
    26

    Extract data from cells above from Power query output

    Hi All. This one has me stumped.

    I have a query which I've imported into excel.
    For every row that begins with WQ I want to populate each cell below it with selected data from from the preceding "WQ" line but only until it hits the next "WQ" line. I've provided some text only example of what I want to achieve.

    Many thanks,,
    Pete
    Attached Files Attached Files
    Last edited by AliGW; 12-22-2021 at 04:20 AM. Reason: Irrelevant section of title removed.
    Reply With QuoteRegister To Reply
  2. 12-22-2021, 03:05 PM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,373

    Re: Extract data from cells above from Power query output

    In J2 and copy down

    =IF(LEFT(A1,2)="WQ",MID(A1,3,8)&MID(A1,22,4)&MID(A1,33,3)&G2,IF(ISNUMBER(LEFT(A2,2)+0),LEFT(J1,15)&G2,""))
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 12-22-2021, 03:50 PM #3
    tiger99
    tiger99 is offline
    Registered User
    Join Date
    01-27-2014
    Location
    Brisbane
    MS-Off Ver
    Excel for Office 365
    Posts
    26

    Re: Extract data from cells above from Power query output

    Thanks John. Works a charm. Much appreciated.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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. Help with Power Query to extract JSON parameter values from the data
    By chandramouliarun in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2021, 01:37 AM
  3. Extract data from Web using Power Query
    By jatin.c in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-23-2020, 08:38 AM
  4. [SOLVED] Extract Data with Power Query and Groupby tool
    By GerryZucca in forum Excel General
    Replies: 7
    Last Post: 06-28-2020, 11:10 AM
  5. [SOLVED] Power Query: Extract data from cells to build a table of data for analysis
    By reddwarf in forum Excel General
    Replies: 13
    Last Post: 05-17-2020, 05:33 AM
  6. [SOLVED] Power Query to Extract Data based on multiple criteria
    By Philipsfn in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 01-16-2018, 01:45 PM
  7. [SOLVED] Power Query: Extract data from table after other rows are filtered
    By JimDandy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-25-2017, 02:10 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1