Results 1 to 13 of 13

Power Query VBA to Omit/Delete & Seperate Data From .CSV

Threaded View

Ourkid123uk Power Query VBA to... 03-05-2019, 08:22 AM
romperstomper Re: Power Query VBA to... 03-05-2019, 08:43 AM
Ourkid123uk Re: Power Query VBA to... 03-05-2019, 09:06 AM
Ourkid123uk Re: Power Query VBA to... 03-05-2019, 09:14 AM
romperstomper Re: Power Query VBA to... 03-05-2019, 09:17 AM
Ourkid123uk Re: Power Query VBA to... 03-05-2019, 09:53 AM
romperstomper Re: Power Query VBA to... 03-05-2019, 10:00 AM
Ourkid123uk Re: Power Query VBA to... 03-05-2019, 10:08 AM
romperstomper Re: Power Query VBA to... 03-05-2019, 10:16 AM
CK76 Re: Power Query VBA to... 03-05-2019, 10:21 AM
Ourkid123uk Re: Power Query VBA to... 03-05-2019, 10:41 AM
CK76 Re: Power Query VBA to... 03-05-2019, 10:46 AM
romperstomper Re: Power Query VBA to... 03-05-2019, 10:47 AM
  1. #1
    Forum Contributor
    Join Date
    02-09-2016
    Location
    West Midlands
    MS-Off Ver
    2016
    Posts
    224

    Power Query VBA to Omit/Delete & Seperate Data From .CSV

    Hi Guys!

    I have a .CSV file which contains listings of horse races for a day which i have imported into Power Query and removed some columns of data that i dont need.

    Im only interested in The Horse Races that have 8,9,10,11 or 12 Runners. Because these files contain all the races for that day and no reference of how many runners for each race, how can i omit or delete all the other races and just leave 8,9,10,11 or 12 runner races?

    I would like to then load these into the worksheet but add a space between each race.


    The only way i could think is to add some VBA code within Power Query that once in race order counts how many Rows have the same start time and there for calculates how many runners there were. How can i manage this data?

    I appreciate any suggestions or help you may have, thanks for looking!


    I have included a copy of my workbook as i think its necessary.
    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] Power Pivot does not load new column added in Power query
    By ibuhary in forum Excel General
    Replies: 12
    Last Post: 02-19-2019, 03:53 AM
  2. Data consolidation - Power Query
    By abdumon7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2019, 11:26 AM
  3. Power query web data pull ?
    By common763 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2018, 08:47 AM
  4. 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
  5. Power Query Error When No Data
    By seethesun in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-22-2018, 10:02 PM
  6. Replies: 0
    Last Post: 04-05-2018, 01:16 AM
  7. Replies: 2
    Last Post: 07-19-2015, 06:04 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1