Combine multiple columns into one

[Alex501]

Hi

I have a set of data in columns and want to combine them all into one column, the data is in a table (named TestTable) laid out like the following;

Using the following formula I've got part way there;

=INDEX(TestTable,1+INT((ROW(A1)-1)/COLUMNS(TestTable)),MOD(ROW(A1)-1+COLUMNS(TestTable),COLUMNS(TestTable))+1)

The result looks like this;

I need the ouput to be in column order as follows;

How I amend the formula for the desired output.

Thanks in advance

 

[Fluff]

Glad we could help & thanks for the feedback.