Transpose Columns into Rows and Add name

[heathqm]

Hello Experts, I want to create a table that looks like this: 

Program Change Summary ($ in Millions)                   Prior Year Current Year 
Previous President's Budget                                              383.322   356.107 
Current President's Budget                                                374.047    356.107 
Total Adjustments                                                                   -9.275       0.000     
 Congressional General Reductions                                 0.000        0.000
 Congressional Directed Reductions                                0.000        0.000
 Congressional Rescissions                                                 0.000       0.000
 Congressional Adds                                                               0.000      0.000
 Congressional Directed Transfers                                    0.000      0.000

Right now when  I load the data it has columns like this: 

[ChangeSummary/AdjustmentDetails/SBIRSTTRTransfer/PriorYear],
[ChangeSummary/AdjustmentDetails/SBIRSTTRTransfer/CurrentYear],
[ChangeSummary/AdjustmentDetails/Reprogrammings/PriorYear],
[ChangeSummary/AdjustmentDetails/Reprogrammings/CurrentYear],
[ChangeSummary/AdjustmentDetails/CongressionalDirectedTransfers/PriorYear],
[ChangeSummary/AdjustmentDetails/CongressionalDirectedTransfers/CurrentYear],
[ChangeSummary/AdjustmentDetails/CongressionalAdds/PriorYear],
[ChangeSummary/AdjustmentDetails/CongressionalAdds/CurrentYear],
[ChangeSummary/AdjustmentDetails/CongressionalRescissions/PriorYear],
[ChangeSummary/AdjustmentDetails/CongressionalRescissions/CurrentYear],
[ChangeSummary/AdjustmentDetails/CongressionalDirectedReductions/PriorYear],
[ChangeSummary/AdjustmentDetails/CongressionalDirectedReductions/CurrentYear],
[ChangeSummary/AdjustmentDetails/CongressionalGeneralReductions/PriorYear],
[ChangeSummary/AdjustmentDetails/CongressionalGeneralReductions/CurrentYear]

I tried to do a crosstable to transpose the data but I am not sure thats the right thing. I need to pull out the Labels because right now there isn't a column that has (Program Change Summary ($ in Millions)  
Previous President's Budget ,Current President's Budget,Total Adjustments, Congressional General Reductions ,Congressional Directed Reductions, Congressional Rescissions, Congressional Adds , Congressional Directed Transfers) as values. I want to make those rows and then have the values be columns.

Sorry I a new to the data load editor and this seems very complex. I hope this makes sense. 

[Kushal_Chawda]

@heathqm  would you be able to share sample file with some data?

[heathqm]

It is an xml file but here is a small sample file