Need to Transpose Countries over Years, For Each Country List All Year Values

I´m not sure if this is what you need.. attached is an example and how to do it.

michaelterenzi 

1.- First transform to a table your data.

2.- Then Data > From Table / Range

3.- Inside the power query editor , First select the Country Column > then go to Transfrom > Unpivot other columns.

4.- You are going to have error because of the N/A.

Select the Column Value > Transform > Replace Errors > (then replace for 0)

5.- Go to Home > Close & Load

*If you want to refresh the data, just go to Data > Refresh all like a pivot table.