Hello everyone,

I'd be really grateful if someone could help me think of a series of steps to get from Point A to Point B. I work in schools, and one of my main sources of data is a very old database with limited reporting. Much of the reporting was designed for a pen and paper age, and is set up with repeating rows at the top of "pages" for example.

Point B (where I want to end up) is very straightforward: I'd like columns for Season, Board, Level, Code, Title and Count of Entries.

But Point A - even when I've refined it a bit (I've done it in Excel for now but could replicate it in PQ) - looks like this:

You can see that the History listing happens twice - because it's over two "pages" with 61 Entries (the candidates are listed beneath and I've filtered them out), whereas the RS listing happens only once - because 11 candidates fit on one "page". I can't work out what steps I could use to make this sensible - has anyone got any ideas?

Thanks for reading!