I want an easy way to take the following data set:
1 2 3
4 5 6
7 8 9
and turn it into a single column of data like this:
1
2
....
9

I know how to transpose data and I can do 3 transpositions for this small
set, but I have hundreds of rows and a repeating application for a function
that will do this. When I use autofill Excel keeps skipping rows of data!
Thanks in advance.