split delimited data into rows - how???

Hi,

1. I would use this formula to arrange the values horizontally,
=SUBSTITUTE(A1,CHAR(10)," ")

2. Use text to column to seperate them into columns

3. Use the copy-->paste special ----> transpose to align them vertically.