Hi Pinch hitter,
Welcome to ExcelFox
I can’t remember much about this Thread, and still I don’t know too much about cricket either.

The simple answer is that most likely in Excel with a formula or VBA we could manipulate data to get any result you want. Most likely there would be almost an infinite ways to do it as well.
To give you a specific solution or more detailed answer attempt I would need a small sample of your data and an example of the result you want to get.

(Or, if an answer here is close to what you want, (coding or formula), then tell me which one, and tell me what you want differently.)
Alan