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.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com