How do I import data but stop importing when a blank cell is found

I want to be able to import data but only to the blank cell How would I do this?

Instead of just ignoring the cell and carrying on I would simply like it to stop

Like this if Row C was the imported data

Sheet with an example of how it'd work