One column in Excel for multiple columns

Transpose will be used, copy the "Selective paste" transpose, but that only applies to the vertical and horizontal, if a column to turn into five columns n rows? (pictured below)

Don't tell me to use the INDIRECT function Ah, this is the intermediate function, not suitable for the vegetable class students ...

Because the relative references of EXCEL itself are working, so in a unit input "=A1", the right to fill will become "=b1, =C1, =d1 ..." but can not directly achieve the right to fill into the "=a2, =a3, =a4 ...", the following figure:

But if you just type "A1" in the cell and then fill it to the right, a miracle appears, as in the following figure:

Using this principle, the transpose becomes very simple, as long as the C1:g5 area is filled with the following image:

But it's not over yet, and then you need to make the data that looks like row numbers into cell references, one by one, and of course not, and you need:

Triple Recommendation: Click for free Download the latest version of WPS Office software "to see more computer tutorials

Find "A" to replace all with "=a"