Help with merging multiple row into same single row cell

Sreepathi You can not merge cells and retain the content of each cell.

But you can create what you want by TEXTJOIN (newer Excel versions) or CONCAT (all Excel versions)

=TEXTJOIN(CHAR(10),,A2:A6)

or

=CONCAT(A2&CHAR(10)&A3&CHAR(10)&A4&CHAR(10)&A5&CHAR(10)&A6)

..... and format the cell with either of these formulae (in this case B1) to "Wrap Text"