change format of text file when loaded

I currently have this script which loads elements from a text file and formats them into an excel sheet.
The format is set to each new element in a new column, I was hoping to change it up so each new element is in a new row.
I tried changing this portion of the script to Rows without success.

Please Login or Register  to view this content.

Thanks
Dale
Below is the script

Please Login or Register  to view this content.

Please Login or Register  to view this content.

then where you have stuff like:

Please Login or Register  to view this content.

change it to

Please Login or Register  to view this content.

Great thanks yudlugar
exactly what I was looking for.
Dale