I want date of Name2 and Name3 in the single column i.e below the data of "Name1". How should I do that?

>Solution :

Use the TOCOL function, e.g.

=TOCOL(A2:D5)