I have 70 rows that is 11 columns deep that I need to put into one long
column using a macro. I want the rows to be consecutively loaded. A
smaller version of what I'm trying to do is this:

Turn this:
1 2 3
4 5 6
7 8 9

Into this:
1
2
3
4
5
6
7
8
9

This needs to be a macro because I receive this data once a day in the
incorrect format. Any advice you have would be appreciated!