The Transpose doesn't work because I am referencing the names from a
different spreadsheet. When I do Transpose the names show up as a " # REF "
and not the actual name.

I hope you understand what I am trying to say.

"KC" wrote:

Copy, then Paste Special Transpose
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"kbr" wrote:

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?