Show 2 Relation Fields from the Same Database in 1 View or Field

I have a few use cases where I have two fields, but I want to show all items from both fields in one (view or field) to make it easier from users. A few examples, but there are many other areas where it’s relevant:

  1. An application has a Case Officer and a Submitter. They both relate to the Project Contacts database and are therefore 2 fields on both databases. This is fine for the Application database, but in the Project Contact, I want to show all Applications relating to that contact in one View, rather than “Applications where this contact is the Case Officer” and “Applications where this contact is the Submitter”.
  2. Projects have Related Projects. Because it’s a relation to the same database, it creates 2 fields. When a related project is added, the current project shows in a 2nd field for the related project. Again, I’d like to consolidate these so users don’t have to check 2 fields/views, which is unintuitive and takes up too much space.

I cannot seem to create a formula that lets me consolidate these 2 fields, or a view that will show both dynamically.