Bruce, here is an alternative using formulas.
Assumptions:
- The original table starts from A1 (headers).
- The columns I will present start from G2. (G1:K1) hold headers.

Column G:G: Aux. Start with the numbers 0, 1, 2, ... as far down as
necessary (i.e. 3*number of data rows - 1)
Column H:H: Num: In H2: =OFFSET($A$2,INT(G2/3),0)
Column I:I: Name: In I2: =VLOOKUP(H2,A:E,2,0)
Column J:J: State: In J2: =OFFSET($C$1,0,MOD(G2,3))
Column K:K: Value: In K2: =VLOOKUP(H2,A:E,MATCH(J2,$A$1:$E$1,0),0)

HTH
Kostis Vezerides