If I have data like the following

A1
A2 Name
A3 Rank
A4 Color
A5

Can I have the contents of the cells A2:A4 appear in a single cell which is the result of the merger of those same three cells?



A1
A2 Name
Rank
Color
A5

I have researched and messed around with Merger and Concatenate but so far to no avail.

Thank you