Create a table from multiple ones

[Atf23]

Hi everyone,
I am new to Power BI, every help is appreciated 🙂

Problem: I have 3 input datasets (see INPUT) where there are a set of documents(content) that is accessible by groups of users (group) but access can be given also via specific groups.
Specific groups are made to allow a subset of users in some group to access documents.

Need: I want to find a way to build the table (see OUTPUT) where I have all the users that can access the documents via the groups or the specific groups.
Thank you 🙂
************  INPUT ************  

OUTPUT

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...