I have two tables. both tables contain a column named 'Company name'. I want to copy the unique data from both the columns of two different tables and paste it into another column (may be in 3rd table).
New column of 3rd table should contain unique records from above two columns. How can I achieve this? Please help me. Thanks!
Note: I want to implement venn diagram in power bi to show common companies hence I want to prepare data in that format.