'How to split a column with very big number into a smaller pieces

I have a big data around 189.000 rows in 1 column. I want to cut it into 5.000 pieces. So I will have 5.000 data in every column. Example like 5000 in A, B, C, D .... Is there any way to do this in excel?

explanation



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source