One or more of the other turns in Excel

Wolf, Wolf, dog, I wrote a piece of Ebaoden is about converting a column into multiple columns, the substitution method is used to deal with the transpose problem. Although the problem can be solved, but the process is still a little trouble, is there any simpler way?

There are two times the fill can be completed!

Conversely, if you are more than one column to a column, it is also two times fill can be completed:

The effect is very magical, I climbed into the cell test to realize the ^_^