I have an Excel document that looks like this:
Country Property Value Canada Capital Ottawa Canada Population 38 Canada Language1 French Canada Language2 English United States Capital Washington United States Population 280 United States Language1 English United States Language2 NA
I want to re-arrange this so that it looks like this:
Country Capital Population Language1 Language2 Canada Ottawa 38 French English United States Washington 280 English NA
Is there any way to do this transformation ? Thanks.