Splitting a list of data into multiple columns

Thanks for looking at my thread. I have a question about Excel. I apologize in advance if I don't do a great job of explaining what I am trying to do, it is kind of difficult to explain..

I am using Excel 2007.

I would like to be able to input a list of text data and have Excel split the list up into different columns. I would like to be able to set a maximum number of cells to use per column. That way, once the list has reached the limit, the next piece of data would be at the top of the next column, and the process would be repeated until there was no more data left.

For example, if I have the following data:

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O

I would like to be able to set a maximum number of cells per column. If I chose to allow a maximum of 5 cells per column, the output would look like this:

A____F____K
B____G____L
C____H____M
D____I_____N
E____J____O

I would like to be able to keep the data in the order in which it was inputted.

Does anybody know how I could do this?

Thanks