Hey folks,
I have a dataset that consists of roughly 4000 observations and I need to expand it so that I duplicate rows based on the value noted in the final column.

Here is a sample of what my data looks like:

Community Zone Population size Date Event Count
B SLZ 446 03/27/2006 ILI 5
B SLZ 446 04/03/2006 ILI 4

And I'd like for it to look like this:

Community Zone Population size Date Event Count
B S 400 03/27/2006 ILI 5
B S 400 03/27/2006 ILI 5
B S 400 03/27/2006 ILI 5
B S 400 03/27/2006 ILI 5
B S 400 03/27/2006 ILI 5
B S 400 04/03/2006 ILI 4
B S 400 04/03/2006 ILI 4
B S 400 04/03/2006 ILI 4
B S 400 04/03/2006 ILI 4

Does anyone know how I can do this using Excel 2003?

Thanks!