Thanks for the excellent tutorial. I've had to create numerous pivot tables over the years and it was a struggle learning them initially. You've laid out easy to follow examples...

Thank you for your replies. I will post a query tomorrow in make table format for all to see. And yes the rows can be anywhere from 1...

Thanks for the replies. My image of the results got pushed together on submit because I had it all laid out in table format. The LAG function does...