Hi All,
Been struggling with this today. I have data that is three rows = 1 record and then starts again, I can't work out how to do it so:

I've looked at a multi row formula, but can't quite figure out how to get it to do what the screen shot shows you, any ideas please?