combine City and Country fields into one field

[andywil456]

I'm trying to do a map visual based on UK towns. The problem is certain towns are classed as US or Australian.

I have read the best way to resolve this is to combine my Towns and Country field into one column. for Example Newcastle, UK. 

How do I merger/combine two columns within the same table and put in a comma to seperate? 

[ImkeF · Accepted solution]

In the query-editor:

Check both columns -> Add Column -> From Text -> Merge Columns -> select "Comma" in the Merge Columns-dialogue