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

Thanks, I'll have a look in more detail tomorrow.

I was thinking of one way to split the laps / PR was to temporarily change the template to put a character in, such as a slash /, so power query could detect the character and split the data.

The 10 lapper in EK is PR86.0 and EC is PR96.0

I was planning to update the master sheet probably once a month, or just before a team event. Once the master had been updated the template could be reverted back to normal.