convert word or text file to Excel

This may sound simple to you all' but for this old man it is driving me to pull out my hair - if I had any...

I have several thousand names in a word/text list:

Club name
Contact name
Address, City, State, Zip
email

I want to import into excel with a different format:

Club name Contact Name Address, City, State, Zip email

in horizontal columns rather than in vertical list.

I've tried transpose - not doing it right I think - doesn't like the cell sizes?
Also imported the text version of the file as comma separated, but it does not give me columns???

Anyone know how I can do this???