Making 13 columns into one column

So I have monthly data and then an annual average. 13 columns in total. Here is a short example.

01-Jan 02-Feb
1 6
2 7
3 8
4 9
5 10

I am trying to get it to look as such

01 1
01 2
01 3
01 4
01 5
02 6
02 7
02 8
02 9
02 10

There are more but I thought this short example would be sufficient. Attachments seem to take forever on here. If you really need it, I can supply one.

Originally Posted by twilcox1978

... Attachments seem to take forever on here. If you really need it, I can supply one ...

It would help to see the overall picture and to play about with some formulae.

Pete

Put this formula in, say, A20:

=INDEX($A$1:$M$1,INT((ROWS($1:1)-1)/10+1))

Format that cell as a date by using the Format Painter icon from cell A1. Then put this formula in B20:

=INDEX($A$2:$M$11,MOD(ROWS($1:1)-1,10)+1,INT((ROWS($1:1)-1)/10)+1)

Then copy both formulae down as far as required.

Hope this helps.

Pete

I am getting a FALSE value in Cell A20. Does it matter that cell A1 is a custom format?

Here's your file back with the formulae in, so you can check if you typed everything properly.

Hope this helps.

Pete