use paste special and transpose the data

"Russ M." wrote:

When importing from a txt file. The data ,which is all seperated by commas,
gets dumped into a row wich is not long enough and cuts off my data. I need
it to dump to a column not a row..Help. Russ