Here is an example how I would do it.
Sheet Hidden, as you can guess, will be hidden.
I started with grouping organizations like in your example (OrgTypes), but dropped the idea and went with organizations instead. The sheet and columns remained, but aren't used.
On Persons sheet, last 2 columns are meant to be hidden too.
On report sheet, you can drag fields with formulas into any position on sheet you want. I prepared only some fields to give you the idea. and of-course you can display organization info on report sheet too (use VLOOKUP).
|