I have a data dump in Excel that consists of annual customer data for two different values. The data was provided with a separate row for value for every year and customer. I.e. it looks like this:
I'm stuck with a row for Customer 1 for Value A in 2009 and a separate row for Value B for the same customer in the same year.
In some instances there is no Value A or Value B. In the example above, you can see that Customer 1 has no Value B in 2011, so no row was generated for that. And, though not represented in the example, some clients will have no data for either value in a year (and thus no row for that customer in that year). In that situation, lacking a row for that customer in that year is fine.
I want to get this into a worksheet where there's one row for both values for every year and customer. I.e., I want the data to look like this:
What is the most effective way to create that result?