hexagon logo

Excel CSV formatting question

In regards to how excel recieves the data, is there a way in VB script to force excel to take the information and display the results along a column as opposed to in a row?

IE:
Typical
####

Wanted
#
#
#
#

I have a file that outputs over the 16,800 something allowable column width, and in rows you can have over 1,000,000 lines.

Thank you to anyone who can assist