Combing multiple rows and column together

[joashkhoo]

Hi all,

Is there a way to transform my data from this to the one below?

	JAN	FEB	MAR	APRIL	MAY	JUNE	JULY	AUG	SEP	OCT	NOV	DEC
2010	1	2	3	4	5	6	7	8	9	10	11	12
2011	13	14	15	16	17	18	19	20	21	22	23	24

Jan-10	1
Feb-10	2
Mar-10	3
Apr-10	4
May-10	5
Jun-10	6
Jul-10	7
Aug-10	8
Sep-10	9
Oct-10	10
Nov-10	11
Dec-10	12
Jan-11	13
Feb-11	14
Mar-11	15
Apr-11	16
May-11	17
Jun-11	18
Jul-11	19
Aug-11	20
Sep-11	21
Oct-11	22
Nov-11	23
Dec-11	24

[Inactive User · Accepted solution]

Solution attached.

[joashkhoo]

thank you Ryan, works well