I know that converting text to columns is simple but i'm wondering if I can
create a macro to conver text to rows?

Would the easist way to do this be simply converting text to columns and
then transposing it to the rows or is there an easier way than this?

My text is e-mail addresses seperated by a comma with no spaces in between
the addresses.

Thanks in advance.