Extracting Records of different row values into one column.

[Sporter11]

I was curious if there was a formula to pull data from three rows and place them into one column even if there are different amount of data in each row. This is similar to excel magic trick 701 and this is the same question that was asked on that page at the bottom.

A----B----C----D----E----F
1---151- 200--119--151
2---125--101--325--125
3---158---95--------158
4--------235--------200
5--------179--------101
6--------------------95
7 -------------------235
8 -------------------179
9--------------------119
10-------------------325
11

 

[alansidman]

response deleted.