hi,
I am not sure what you are taking about with the link part.
but the other i can help.
copy the business name, address,city. then in cell a2( or
wherever to want it) click editpastespecialtranspose.

-----Original Message-----
I have a worksheet that I have downloaded a list of
businesses on. Unfortunately, the list is in one column,
the name of the business in row 1, the address is in row
2, the city is in row 3, etc. I would like to format the
information so that the name of the business is in one
column, the address is in the second column, the city is
in the third column, etc. I am pretty sure that there is
a way to do this, but do not know how. Also, I would
like
to know how to change information that is a link. I
would
like to change this information to regular type. Is
there
a way to do this? Thanks for the help.
.