I'm trying to select a list of different documents - documents in one table, document categories in another - and organize the list by categories. I've been looking around for a solution but haven't really found anything that does what I'm looking for. I'm probably not using the right terms or perhaps it can't be done. Either way, I hope I can get some input here.
I'm including a file that has two tiny examples for tables and some data - some 4 records in total - the real data could have up to 100 documents across multiple document categories - but this should illustrate the point of the output format I would like to get.
As I said, I've no idea if this is possible or not - I've been told it is, but so far, I've not figured it out. As always, many thanks in advance for your time.