+ Reply to Thread
Results 1 to 12 of 12

Extract Data from inconsistent number of rows

  1. 04-26-2024, 09:38 AM #1
    DarrylBurge
    DarrylBurge is offline
    Forum Contributor
    Join Date
    07-07-2014
    Location
    Nottingham
    MS-Off Ver
    Office 2016
    Posts
    387

    Extract Data from inconsistent number of rows

    The attached data is what our Tracking System exports for items that have to be washed for a second time.

    I have been asked to see whether we can compile a report from this data in a relatively simple way.

    I want to be able to extract the following data:

    Accountable Operator
    Date Raised
    Time Raised
    Description (See lines H20 - H28)
    Description (See line E11) where there is no line similar to Row 19

    I imagine it will have something to do with whenever the Log Number changes, or something of that ilk, so was wondering if someone was able to point me in the right direction
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-26-2024, 10:18 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,139

    Re: Extract Data from inconsistent number of rows

    Please amend your sample file to show expected answers.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 04-26-2024, 10:41 AM #3
    DarrylBurge
    DarrylBurge is offline
    Forum Contributor
    Join Date
    07-07-2014
    Location
    Nottingham
    MS-Off Ver
    Office 2016
    Posts
    387

    Re: Extract Data from inconsistent number of rows

    Added. Thank you.
    Attached Files Attached Files
    Last edited by AliGW; 04-26-2024 at 10:44 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
    Reply With QuoteRegister To Reply
  4. 04-26-2024, 10:54 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,139

    Re: Extract Data from inconsistent number of rows

    If you wany the highlighted results returned... in the indicated format, I >>think<< this will be a nightmare if you're still using Excel 2016. It MIGHT be possible if the purple results werte all returned in a single row along with the yello header information... but it would still be a nightmare.

    Are you OK with VBA? I won't be able to help... but others may. I can move the thread if VBA is a runner.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 04-26-2024, 11:16 AM #5
    DarrylBurge
    DarrylBurge is offline
    Forum Contributor
    Join Date
    07-07-2014
    Location
    Nottingham
    MS-Off Ver
    Office 2016
    Posts
    387

    Re: Extract Data from inconsistent number of rows

    Hi Glenn

    Yes, I thought it would be a nightmare - just by the way the worksheet it laid out.

    Yes, More than happy for you to send this over to VBA.
    Reply With QuoteRegister To Reply
  6. 04-26-2024, 11:25 AM #6
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,139

    Re: Extract Data from inconsistent number of rows

    Moved. Good luck!!
    Reply With QuoteRegister To Reply
  7. 04-27-2024, 03:08 AM #7
    JohnTopley
    JohnTopley is online now
    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,336

    Re: Extract Data from inconsistent number of rows 

    Please Login or Register  to view this content.
    Input sheet named "Data" and output is "Report" which has "RUN" button.

    NOTE: heading in E is "Decription" not (as expected) "Description" so code (higlighted) needs amending for change in this title.
    Attached Files Attached Files
    Last edited by JohnTopley; 04-27-2024 at 03:17 AM.
    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
  8. 04-27-2024, 03:45 AM #8
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,575

    Re: Extract Data from inconsistent number of rows

    try
    Please Login or Register  to view this content.
    Edit:
    Now I see what you meant by "Do not mind if this area is blank or if it repeats the line above"...
    Attached Files Attached Files
    Last edited by jindon; 04-27-2024 at 04:39 AM.
    Reply With QuoteRegister To Reply
  9. 04-27-2024, 03:49 AM #9
    JohnTopley
    JohnTopley is online now
    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,336

    Re: Extract Data from inconsistent number of rows

    Another version with "Description" plus aligned Descriptions in single column

    Please Login or Register  to view this content.
    Macro is "Demo2"
    Attached Files Attached Files
    Last edited by JohnTopley; 04-27-2024 at 08:39 AM.
    Reply With QuoteRegister To Reply
  10. 04-27-2024, 06:50 AM #10
    daboho
    daboho is offline
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,397

    Re: Extract Data from inconsistent number of rows

    Perhab
    Please Login or Register  to view this content.
    Last edited by daboho; 04-27-2024 at 07:15 AM.
    Reply With QuoteRegister To Reply
  11. 04-27-2024, 07:48 AM #11
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,284

    Re: Extract Data from inconsistent number of rows

    And so the options keep coming...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  12. 04-27-2024, 02:15 PM #12
    daboho
    daboho is offline
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,397

    Re: Extract Data from inconsistent number of rows

    Deleted ......
    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. [SOLVED] Extract specific strings that is next to a specific text - inconsistent data format
    By pbjgun in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-08-2022, 06:29 AM
  2. Using offset to convert one column to multiple rows when data is inconsistent - HELP!
    By markpgates in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-03-2022, 05:40 AM
  3. Macro inserting data after several blank rows - inconsistent
    By ashley72788 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2017, 08:17 AM
  4. [SOLVED] Conditional Formatting complete rows in data table - inconsistent
    By BuZZarD73 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-13-2014, 10:31 AM
  5. Need help to auto extract rows of data based on customer number into individual tabs
    By fatkitten in forum Excel General
    Replies: 3
    Last Post: 09-26-2014, 01:07 AM
  6. [SOLVED] Use a formula within a macro to extract data and copy down x number of rows
    By rdowney79 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-15-2013, 12:25 PM
  7. Inconsistent data rows
    By junada0 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-12-2010, 04:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1