Dear Sir,


Please Help. Pls. find attached the "Sample" excel sheet. I need to copy the Top Country details in the Respective Country Column.

For Example:

India Details (Column D)

In India Column (Column D) , India Country Name and Percentage should be captured from Top Country Visitors Column (Column C)

United States Details (Column E)

In United States Column (Column E) , United States Country Name and Percentage should be captured from Top Country Visitors Column (Column C)

Other Country Details (Column F)

In Other Country Column (Column F) , country names other than India & United States needs to be captured.


The desired output to be achieved is highlighted in Yellow. Please Help. Thanks in advance.