I have a set of names which are listed in a single row in different columns.
Like Column A has one name and then column B has other name and so on upto
column CZ. All are liste on the same row. Say Row number 3. Now I want to
use these names as a reference in a different sheet of the same excel file.
But, I want the names to be listed vertically instead of them being
horizontally. In short, I want the names to be in different rows but in same
column.

How do I go about it?