How to convert random XML into RSS with linq

Question

I have this XML data dump

<?xml version="1.0" encoding="UTF-8"?>
  <File>
    <Row>
        <Column Name="Job Code"></Column>
        <Column Name="# of Positions"></Column>
        <Column Name="Justification (Text Only)"/>
        <Column Name="Reason"></Column>
        <Column Name="Job Title"></Column>
        <Column Name="Purpose (Text Only)"></Column>
        <Column Name="Requirement (Text Only)"></Column>
        <Column Name="Responsibities (Text Only)"></Column>
    </Row>
  </file>
</xml>

As you can see the name attribute has the column type and this is about as much use as hole in the head. What I wish to do is convert this into RSS using Linq but I am struggling to work out how to create a data object from this XML

I have worked out how to walk through the columns with select case block. But I would like to LINQ to get an object that I could then pass into the RSS generation function