I have a MS Access report that is output to a text file. What is the best way to transform what I need into XML or the MS Access report into a tabular format?

For example:

The report is grouped by state. I need to denormalize the group and have the state repeat as a column or field.