Hi, I have a question about creating a chart from two columns. In the first column I have different text entries, some of them appear various times. In the second column I have percentages attributed to the data of the first column. In my chart I want to have only one outcome for each text entry with the average value of all values. I don't want to have two points for Paraguay for example, but only one who shows me the average percentage of all the percentages for Paraguay. See example below. Does anyone know how to do this?? Thanks!
Paraguay 14.00%
Uruguay 12.90%
Paraguay 11.32%
Ecuador 9.56%
Uruguay 8.89%
Venezuela 8.89%
Paraguay 8.70%
Uruguay 8.02%
Uruguay 7.92%
Bolivia 7.69%
Ecuador 7.34%
Ecuador 7.14%
Ecuador 6.98%
Colombia 6.91%
Paraguay 6.90%
Bolivia 6.82%
Ecuador 6.82%
Chile 6.81%
Ecuador 6.67%
Venezuela 6.64%
Venezuela 6.62%
Venezuela 6.52%
Venezuela 6.40%
Uruguay 6.37%
Venezuela 6.26%
Chile 6.24%
Colombia 6.12%
Uruguay 6.06%
Venezuela 6.05%
Ecuador 5.77%
Venezuela 5.72%
Uruguay 5.66%
Chile 5.61%
Peru 5.57%
Bolivia 5.51%
Paraguay 14.00%
Uruguay 12.90%
Paraguay 11.32%
Ecuador 9.56%
Uruguay 8.89%
Venezuela 8.89%
Paraguay 8.70%
Uruguay 8.02%
Uruguay 7.92%
Bolivia 7.69%
Ecuador 7.34%
Ecuador 7.14%
Ecuador 6.98%
Colombia 6.91%
Paraguay 6.90%
Bolivia 6.82%
Ecuador 6.82%
Chile 6.81%
Ecuador 6.67%
Venezuela 6.64%
Venezuela 6.62%
Venezuela 6.52%
Venezuela 6.40%
Uruguay 6.37%
Venezuela 6.26%
Chile 6.24%
Colombia 6.12%
Uruguay 6.06%
Venezuela 6.05%
Ecuador 5.77%
Venezuela 5.72%
Uruguay 5.66%
Chile 5.61%
Peru 5.57%
Bolivia 5.51%
