I have a dataset where I need a single row for every event type that happens at a given time. 10,000-20,000 rows total.
Instead of entering each row manually, I would like to have a column with the number of events that happen on a given day, then use that value to add that number of rows for each event type.
For example, there are 89 events of type 1 on day 2, 76 events of type 1 and 36 events of type 2 on day 3. I would want a datasheet that reads the cell value 89, and adds 89 rows of type 1 day 2 to the sheet, then 76 rows of type 1 day 3, 36 rows type 2 day 3, etc......
Is there a package that would allow me to read that value and create that number of rows for that value in my datasheet?