Need Help to extract data from DotNet XML format????

Hi Gurus,

Good afternoon. I would like to get the values in the following way

Data would be like

      TransactionID,Club_Number,Club_Activity_ID,Status,TicketCount,Usage,BadPulls,Discrepancy, (Values right after <MeterTransaction)

       Bar_Number,TicketCount,Usage,BadPulls,Discrepancy,Display (Values come from <diffgr:diffgram .../<ClubMeter xmlns=/<MeterBar diffgr:id ......   </ClubMeter>)

       Bar_Number,DISPLAY (Values from <diffgr:before>/<MeterBar xmlns= ........ </MeterReading>      </diffgr:before>

All the values should be one line based on ClubNumber/BarNumber.

Based on abbreviated xml sample, I should have 4 lines.

I would really appreciate your help.

     

<MeterTransaction xmlns:CorralClub="http://webservice.hlsr.net/CorralClubService/">

  <TransactionID>0</TransactionID>