I have a table with data in a format like: AA01, AA02, AA03... AA10, BA01, BA02, BA03... BB01, BB02, BB03, etc.
How can I set up a report so that each collection of data that starts with the same two characters is in its own column?
Is there a way to do it with a single main report? Or do I need to set up subreports for each column?
If it helps, the number of entries for each column is the same. I know I can achieve what I want by creating a multi-column report and adjusting the size of the page so it wraps at the correct points, but that seems prone to error.
- Dave