OK computer nerds, I have a stumper for you. I have a huge data set that I need to consolidate. It is like this:
So the deal is, on any particular date, any of the population may have one or more entries, which are coded Apha, Beta, or Gamma, and also have colors associated with them.
But for my purposes, all I care about is on any given data, if a particular person has (a) an Alpha or a Beta, and (b) a Gamma. I don’t care about the colors. So I want to consolidate the above list into something like this:
Any thoughts? Unfortunately I can’t do any neat tricks with a Pivot Table, because the list is so big that it doesn’t fit on one sheet. (And I don’t think you can do a Pivot Table on more than one sheet of data?) So my plan is to take the original list in small chunks onto a new sheet, and then apply the consolidation to each chunk, and then combine all the output into one final list that will fit on a single worksheet to which I can then do the Pivot Table jiu jitsu.
Any ideas? I’m assuming I need to write a macro for it, but as in economics, I am not good at macro.