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.