Convert Array to list

[cgalla]

I have a data array which i would like to convert to a list.
Sort of the reverse of a Pivot Table

See example below
I would like to turn this

Account Jan Feb Mar April etc..
001 59 30 25 40
002 12 20 32 29
003 5 13 27 39
004 10 11 12 13

Into This

Account Month Amount
001 Jan 59
001 Feb 30
001 Mar 25
001 April 40
002 Jan 12
002 Feb 20
002 Mar 32
002 April 29
003 etc...

There is a sample of the data file attached
Any Ideas ?

[arthurbr]

Hi and welcome to the board,
there's an awesome method described here

HTH

[cgalla]

Hi arthurbr !

I have no idea how that works but it works a treat !
Many thanks for that

Cheers !

[arthurbr]

To be honest I don't either (lol)