Hi,
I've done this in the past, but can't remember the exact steps I took - but I recall it wasn't that complex.
I have a list of zip codes, along with the corresponding number of times I want them to appear. So in a separate area, using formulas, I want 12345 to show up 8 times, and then underneath that 12346 to show up twice, etc. Another way of saying it would be that let's assume someone gave me a hardcoded pivot table summary of a count of zip codes, I want to convert that back into raw data.
A coworker showed me how to do this once with a vlookup (I want to say it was an approximate match?), but I can't remember what the steps were.
12345 8
12346 2
12347 1
12348 2
Thank you!
Bookmarks