Board Thread:General Discussion/@comment-27006659-20160418175659/@comment-27006659-20160503225508

RR3 Michael P wrote: 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.

''That sounds fine, and I don't see a problem with leaving it like that. What about all the manual line breaks? I poked around a bit, and for the most part it seems the tables wrap fine on their own when they're removed.''