Macro for converting aggregate to case level data

**epi** · 10-25-2010, 11:37 AM

I'm struggling to convert my aggregate data into case level data. I want to create a macro that inserts duplicate rows based on the number of cases listed in the case count column (column E).
i.e. if I have an entry that says on October 25, 2010 (date variable, column A) there were 15 cases (case count, column E), then I would like to insert 14 additional rows that are duplicate entries for the reference date. Eventually I will delete the case count column and insert a case ID value (i.e. 1 to 15) for each of the cases on each particular date.

I'm completely stumped on how to do this and would really appreciate your input!

**Leith Ross** · 10-25-2010, 11:50 AM

Hello epi,

Welcome to the Forum!

The IDs can be added automatically as the rows are expanded. Does the number 1 get assigned to the earliest date and 15 to the oldest?

**epi** · 10-25-2010, 12:01 PM

Hey Leith,
thanks for the warm welcome!

I'd prefer if the ID variable was reset for each date (I have data from 2006 to 2010), but if this is too complicated, I don't mind if it does this automatically based on oldest to newest dates.

**Leith Ross** · 10-25-2010, 12:10 PM

Hello epi,

Okay, I'll take this a step a time. It would be easier to follow and to write the code if I had a workbook. Can you post a copy of the workbook?