'Pivot table for same types of values in different columns

I have this dataset where the same person could be in two different columns and so his/her sales records. Is there any way to see their aggregated sales record by person and country using pivot table?

MS Excel 2016

Dataset sample and the way Pivot table should be

excel pivot-table

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Pivot table for same types of values in different columns

Sources

Related Questions