Transposing Data From "wide" To "long&quot

Suppose I have numerical data in Excel within the following columns: Column A: ID, Column B: Amount1, Column C: Amount2, Column D: Amount3 (the column headers are in the first row of the file). So in my Excel file, the first couple of rows of data would look like this:

ID Amt1 Amt2 Amt3
40 7.2 4.6 9.7
80 3.4 6.7 1.3

I want to transpose the data so that there is only one amount per row of data (the data should look like the example below):

40 Amt1 7.2
40 Amt2 4.6
40 Amt3 9.7
80 Amt1 3.4
80 Amt1 6.7
80 Amt3 1.3

This is pretty simple to do using proc transpose in SAS, but was wondering if it was possible to do this "wide" to "long" data manipulation in Excel as well (or even Access if easier to do there)?