If you have excel file having the data as above. just load the file into QV.
I am not able to understand what is the difficulty you are facing.
please elaborate your Question.
You can add a load filter to fill in empty values:
Load Column1, Column2, Column3
(ooxml, embedded labels, table is Table1, filters(Replace(1, top, StrCnd(null))));
You can build such a filter with the transformation wizard. See here for an example.
clicking Table tab
Load your data
Next from File Wizard : File Wizard : TransaFormation
Enable Transformation Steps
go to Fill Tab
click "Fill" Button
Specifiy the target Column and go to Cell Condition and say ok without changing any settings
once you say ok, now you`d see the empty rows would have been filled with the informations and say Next and Finsih.