XML Columns To Rows

I have a large amount of data in an XML file. The file is very simple. Off of the root node are category nodes and each category node has many detail nodes. The detail node consist of the node name and the node value. Rather than map the detail to matching named fields in a single record, I would like to send the detail node data to individual data records where the category code, node name and node value are the only fields in the record. For example,

Starting with

<Category>

<Code>001</Code

<Details>

<DetailCode123>75.87</DetailCode123>

<DetailCode728>12.98</DetailCode728>

<DetailCode387>55.72</DetailCode387>

</Details>

</Category>

I want to be able to pick up the 001 code for the category and then transform the above data into 3 separate table records with the following fields (CatCode, DetailCodeName, DetailValue).

001, DetailCode123, 75.84

001, DetailCode728, 12.98

001, DetailCode387, 5572

Does this sort of transform exist? If not, I will have generate my own parsing script. Thought it was worth asking before doing the additional work.

Thanks