The second goal is to split the Country and City column into two columns:

1. Right-click on the Country and City column and click on Split, as shown highlighted in the following screenshot:

2. Tableau automatically recognizes that there is a common character and uses it to split the column into two new ones: Country and City—Split 1, and Country and City—Split 2.
3. Right-click on the new columns and select rename. Rename the first one Country, and the second one City.

The result is displayed in the following table:

If Tableau cannot find a character for the split, or if Tableau chooses the wrong one, you can use a Custom Split to have advanced options. Selecting Custom Split... opens the following window:

That's two problems fixed! Let's finish with the pivot.