A B C D
1 France Spain Italy
2 400010 6 % 1 % 3 %
3 400020 2 % 4 % 3 %
4 400040 1 % 2 % 3 %
5 .
6 .
7 .
8
I would like to put in the percentages into another sheet that looks like
this:
400010 France 6%
400020 Spain 4%
400040 Italy 3%

How can i do that. I've tried with if sentences but it does not work