Filling in Data Using Vlookup

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!

Here's one way that will work in Excel 2003:

https://www.extendoffice.com/documen...e-x-times.html

Thanks, this worked!

I also figured remembered the vlookup method. You build a cumulative counter as your approximate match vlookup column...so for my data, it'd be:

0 12345
8 12346
9 12347
11 12348

You can then just make dummy data, with numbers 0, 1, 2, 3, etc going down the column, and then using an approximate match vlookup next to it it fills in the range.