I have a list of 1000 keywords for each of seven sites, with values assigned to each keyword-site combination.
I need this list re-jigged so that it’s a single list of keywords, with the site and value for each site next to each keyword.
I’ve attached a simplified example of what I’m talking about.
If at all possible, I need you to do this with your formulas intact, so that I can plug in ANY set of seven sites with 1000 keywords and values for each site and have it generate a single list of keywords with a total value for each keyword and the sites and values that relate to the keyword next to it.
I realize that the simplest way to do the project is some sort of cut and paste, but that wouldn’t allow me to re-use your work for new lists down the road. But if it can’t be done elegantly with formulas, then just let me know how you plan to approach it in your bid.
