How to make a table from a column of data?

Question

excel

There is a data column of 800 cells, it is necessary to transform it in an orderly manner into a table of 4 rows.

What are the ways to do this?

Answer 1

In C1, insert the formula:
Drag down 4 cells and then to the right. (solution for those who don't have Kutools add-on)