How do I convert an Excel data table into database format?

in a simple example I want to convert a table like:


SKU DESC Jan-12 Feb-12 Mar-12
123 prod1 10 42 34
345 prod2 90 10 39



Into database format like below, so that I can do data analysis with pivot table.

SKU DESC MONTH QTY
123 prod1 Jan-12 10
345 prod2 Jan-12 90
123 prod1 Feb-12 42
345 prod2 Feb-12 10
123 prod1 Mar-12 34
345 prod2 Mar-12 39

I know I can manually copy and paste the data [as links, so it will auto update if data changes in source tables], but its just too manual, especially when I have several Excel files with the same physical table design that come in every month.

You can notice that the first 2 columns are preserved in the database design, but the month row was transformed in column and the values [quantities] were also transformed in column.

Is there any automated way to do this physical format conversion?
Maybe through a macro template that can be customised?