EXCEL copy entire table to one single column

EXCEL copy entire table to one single column
============================================

1. select all table data (no headers).
2. right click and select "define name" in the context menu.
3. give it a name, for example "MyData".
4. select an empty cell in the column where you need the data and paste the following formula:
=INDEX(MyData,1+INT((ROW(A1)-1)/COLUMNS(MyData)),MOD(ROW(A1)-1+COLUMNS(MyData),COLUMNS(MyData))+1)

NOTE: make sure the formula contains the correct name you defined.