reshape area
 

I would like to convert something from being laid out in
rows to being in columns in an automated fashion. Below
is an example, but the size of the data I am actually
using is much larger.

In cells A1:G3 I have the following data:

AM TM C0 C1 C2 DV PR
60 60 25.00 0.04 12.02 2.42 1.00
144 132 0.32 10.28 0.60 2.84 2.00

I want to convert it to be:

ID AM TM VAL PR
C0 5 5 25 CC
C1 5 5 0.04 CC
C2 5 5 12.02 CC
DV 5 5 2.42 CC
C0 12 11 0.32 AR
C1 12 11 10.28 AR
C2 12 11 0.6 AR
DV 12 11 2.84 AR

which is in I1:M9.
In the process I divided teh AM and TM by 12 and converted
PR from numeric to character (1=CC, 2=AR).