Columns from multiple sources into a single column of distinct values

[Cybe]

Hello,

  I have dissimilar data sources with one column of like values, and I'm unsure how to join them;  I may be asking the wrong question in my searches for 'combine', 'summarize', etc.  

Source 1

Device	Firewall Status	Irrelevant Data
COMPUTER1	Off	Apple
COMPUTER2	On	Orange
COMPUTER3	On	Lemon

Source 2

Computer Name	Antivirus Status
COMPUTER1	True
COMPUTER4	False

Source 3

Hostname	Internet Facing	Other Data
COMPUTER2	Fully	null
COMPUTER3	Partially	Yes
COMPUTER5	Partially	null

Desired Output (A matrix table)

AllComputers	Internet Facing	Firewall	Antivirus
COMPUTER1	null	Off	True
COMPUTER2	Fully	On	null
COMPUTER3	Partially	On	null
COMPUTER4	null	null	False
COMPUTER5	Partially	null	null

I've tried to achieve this via Merge as New, OUTER JOIN in Transform Data, but the result is multiple 'Computername' type columns.   My situation is similar like the post below - but adapting the UNION solution returns, 'a table of multiple values was supplied where a single value was expected'

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Repeating-quot-Key-quot-column-value-in-Calcu...

What am I missing?  Any help appreciated!

[Cybe]

Thank you @ryan_mayu, your attachment contained the answer I needed; 
For future searchers, I created a New Source / Blank Query, and input:

= Table.FromList( List.Distinct(List.Combine({#"Source 1"[Device],#"Source 2"[Computer Name],#"Source 3"[Hostname]})))

This produced a single column of all computers from the three sources. 

Then, merge in each of the original sources (left join on computer name) to produce the desired output.

Thank you @ryan_mayu!  

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

@Cybe 

you can do this in pq.

pls see the attachment below

you can also use DAX to create a table

Table = 
VAR tbl=DISTINCT(UNION(SELECTCOLUMNS('Source 1',"AllComputers",'Source 1'[Device]),SELECTCOLUMNS('Source 2',"Allcomputers",'Source 2'[Computer Name]),SELECTCOLUMNS('Source 3',"Allcomputers",'Source 3'[Hostname])))
return ADDCOLUMNS(tbl,"Internet Facing",maxx(FILTER('Source 3',[AllComputers]='Source 3'[Hostname]),'Source 3'[Internet Facing]),"firewall",maxx(FILTER('Source 1',[AllComputers]='Source 1'[Device]),'Source 1'[Firewall Status]),"Antivirus",maxx(FILTER('Source 2',[AllComputers]='Source 2'[Computer Name]),'Source 2'[Antivirus Status]))