A row is a row is a row Doug Finner 13.Jun.12 11:21 AM a Web browser Domino Designer All ReleasesAll Platforms
There isn't any simple way to flip a view; a row is a document and that's just the way it works. You're not allowed to do dbLookups in column formulas so I'm pretty sure you'll need to get tricky.
Option 1: Write an agent that extracts the data into excel.
Option 2: Write an agent that creates Notes doc based on the client and grabs all the data across months, then display those docs in a view. If you scheduled this to run monthly (or more often), then the data would be semi-live; just remember you'll want to either get rid of the 'old' data or find and update existing records so you don't wind up with duplicate records for a client.