Import from Excel - Advanced Editor question

[sherylmeg]

I'm trying to import an Excel spreadsheet but the data in the sheet has rows grouped by date. An example:

Item	Ship Date
522	Jan-20, 2018
747
642
834
414	Jan-21, 2018
996
568

All the Items on and below the row with the date have the same Ship Date until the next row with a Ship Date then all the Items have that Ship Date, and so on. Is there a way to code in the Advanced Editor something that will get the Ship Date and apply it to all following rows that have no Ship Date until the Ship Date changes (then apply that Ship Date and so on)?

Any other ideas on how to get the Ship Date on each row?

[Sean · Accepted solution]

@sherylmeg

In the Query Editor - right-click on the ShipDate Column Header and select => Fill => Down