Is there a way to break up a single column of data into multiple columns?

I import data from an external source, a list of names. It's all in one
column. Is there any way to format or program so that Excel will break up the
single column into multiple columns, say 50 each, and place the columns side
by side?

I know if this was in Word, I can format the page as columns, though I can't
specify the number of lines I want in each column.