Converting Monthly Columns into Single Month Column

[jgj1988]

I am trying to convert the following:

[pre]

Sku	Jan Cost  Jan GSV   Feb Cost  Feb GSV
1	1	     5	        2	 10
2	2	     4	        2	 4
3	3	     6	        3	 6
To Look Like this:


Sku	Cost	GSV	Month
1	1	5	Jan
2	2	4	Jan
3	3	6	Jan
1	2	10	Feb
2	2	4	Feb
3	3	6	Feb

[/pre]
I have to do this to several files with hundreds of thousands of lines. I would like to know what the fastest way to do this either with VBA code in excel or access.


Thank you,


James

 

[Mike86]

Do you have/want a new spreadsheet for every year or will you be needing a column for the years as well?

 

[jgj1988]

Each file is only for one year period.