Capture.PNG
I am trying to figure out a formula or Excel function to automatically generate new rows based on the range in a cell, and preferably duplicate the dates/other information in other columns stemming from the base row.
As an example, observe the middle row in the attached image. I need to turn that one row into 144 rows, numbered consecutively from 430925 to 431069, preferably duplicating the date in the same row.
I've got to do this more times than easily convenient, so I'd prefer it if there was a simple formula a I could use in a blank column to properly expand the range into individual rows, or a tool in excel I could use on the main column.
I know this is a long shot, but any advice would be great. Cheers.
Bookmarks