I have two different columns in the same table that contain data, and I need the unique values obtained by combining both columns.

In this scenario, all team names are split between the two columns. I need to combine these two columns into one, ensuring that the resulting column contains only distinct values from both.

In the ‘Away Teams’ section, there are four countries—El Salvador, Indonesia, Israel, and Kuwait—that are not found in the ‘Home Team’ column. To calculate the winning count for each team, how can we incorporate these teams into the list?