I have a data table with 1.6M rows. This data table was formed by concatenating many smaller data tables. Unfortunately, these smaller data tables have gaps in many of the columns. For instance, there will be several thousand rows that were all written on the same date, but the date and timestamp is only filled in the top row of the smaller data table. This means I have a data table which has the date field filled-in on only every 9,000-12,000 rows, with everything in between being blank.
Is it possible to have some sort of smart fill where it fills in empty rows with a value until it reaches a non-empty row and then starts filling in subsequent rows with this new value? It would take an eternity to do this by hand with the crappy fill-to-row command for each batch of 10K rows in my 1.6M row long data table.