Excel Question - How to denormalize data?

[uvamarkg]

I need to write an automated process to take a csv/flat file and de-normalize it: example below:

Current Form: Name Age Height EyeColor
Joe 25 5'10 Blue

Form needed:
Name Attribute Name(From Col Header) Attribute Value
Joe Age 25
Joe Height 5'10
Joe EyeColor Blue

Any ideas? Can Excel/Access do this sort of transposing?


Thanks in advance..