Board Thread:General Discussion/@comment-27006659-20160418175659/@comment-25956839-20160502163144

I've been working on my first project with Power Query

https://drive.google.com/file/d/0B6uKlpOGVVLvcTZBMWdXN21PZTA/view?usp=sharing

I've imported the 88 series pages. I've used it to update RR3 Wiki:Pages That Need Editing.

I now want to create the first tab, as master page for all 88 series, which can be imported as a master database back to the Wiki, allowing it to be sorted, so racers can find particular races or race track. Or an excel sheet which will allow the data to be filtered.

Each series is currently a separate tab, I've been working on PSC, the query removes /laps from endurance races, adds a dash to tracks with variants, splits R$ and CRB, formats them as numbers. I have a few questions.


 * 1) Can the power query created on PSC be transferred / added to the other 87 power queries (other than copying and pasting in advanced editor)?
 * 2) Is there a more elegant way to create the master page?
 * 3) Maybe a new excel spreadsheet could be created leaving one with 88 tabs and a new one with 1 tab with the 88 queries appending, if that is possible?
 * 4) Do you have any suggestions on how to split Laps/PR, as there are the odd 10 lappers?

Thanks in advance for any helps and advice.