I'm having a problem with organizing my excel data. Because of the nature of the way the data is entered into excel the data is in one long column, which can range from about 200 to 20000 rows long. I need to find a way to take groups of 10 rows (say rows 11-20) and move them next to rows 1-10 in the next column over (column B), and continue this all the way down the original column (A). The information in the cells are all numbers with some random N/A's from time to time.

For example:
From To
A A B C
1 1 4 7
2 2 5 8
3 3 6 9
4
5
6
7
8
9

I have tried to use If, then statements and attempted a macro, but that level of excel expertise is out of reach. Any information would be extremely appreciated.