"Union" function to merge multiple collections into a single collections field

I’ve seen this pop in many different threads but don’t think there’s an official feature request for it.

I’d basically like the same functionality of “Join()” only it returns a collection of entities instead of a text field.

Here’s the “Get Help” thread with the most conversation around the need for this feature: How to union two list fields in the same Database?