You won't be able to populate field values using the value from the previous record when using database-type sources as you can when working with report sources, such as you described.
Instead you'll need to fill in those spaces in the Excel file prior to using it with Monarch. A quick way to do so is to select the first cell in the range, in your case, the Department title. Hold the Shift key, then click the last row of the column adjacent to that column that does have values (the Maria cell).
Now hit F5 to "go to" and select Special... then Blanks and click OK.
Now before you change anything, hit the + key and up arrow. Now hold Ctrl and hit Enter. Finally, select all of the affected selection and Ctrl-c to copy, then Edit, Paste Special Values and save your file.
Now you can use it with Monarch.
If this is going to be a repeated activity you could write a little Excel macro to handle this cleanup work for you.
To avoid using macros, or doing a manual task in Excel, there is a way to populate these cells by preparing the data in Monarch first.
If you open the Excel file in Monarch, export the table as a fixed width text file, then you'll be able to take the data in again as a report with the option to populate the blank cells.