Transposing 10 colums into 1 column

[Tokkie]

I have a spread sheet that contain monthly budgets for cost account numbers. The account numbers are in col A and the budgets for Apr to Dec are in columns B to J.
We would like to reformat this so that one would have the first account dispayed in A1 with the Apr to Dec budgets in A2 to A10 then the next account (currently in A2) in A11 with this next one's budgets in A12 to A20 and the 3rd account in A21 with monthly budgets in A22 to A30 etc. There are approximately 1000 accounts with budgets that we wish to convert to be in one column. Pleas assist with any suggestions on how I can do this,

[NBVC]

Assuming the data is in Sheet1, A1:J1000

Then in Sheet2, A1 enter:

=INDEX('Sheet1'!$A$1:$J$1000,CEILING(ROWS($A$1:$A1),10)/10,MOD(ROWS($A$1:$A1)-1,10)+1)

copied down as far as necessary to get all data.

[Tokkie]

Thank you NBVC, you are the cleverest Canadian I have had to do with today and I am in South Africa and it is already 02:50 in the afternoon. Thanx.