As Paul suggests, both my Many to One add-in and the similarly conceived add-in from Doug Robbins, will easily handle this task. However there is one proviso in respect of my add-in, (and I believe Doug's would be similarly effected), you cannot have empty rows of data, so in the case of your worksheet, you would have to eliminate them before running the merge.
e.g.
