Excel macro to combine cells from different rows based on value of another row

[klhtgh]

Does anyone have a macro (or some other Excel solution) to combine cells from different rows based on a sequential number from 1 to 25 in another row (while also concatenating a space between the merged cells). I have attached a sample spreadsheet with some data and a sample of the desired output. Thank you for your help in advance!