Using a RTF template, how to transpose rows to columns and the output in xls should show the values

Hi,

Is there a way to transpose rows to columns and continue adding dynamic columns? Can this be achieved using a RTF template? The output needs to appear in seperate cells.

The data xml as below:

<?xml version="1.0" encoding="UTF-8" ?>
<Marksheet>
<marks>
<Serial>1</Serial>
<mark>
<subject_name> english </subject_name>
<subject_mark> 90 </subject_mark>
</mark>
<mark>
<subject_name> history </subject_name>
<subject_mark> 80 </subject_mark>
</mark>
<mark>
<subject_name> Science </subject_name>
<subject_mark> 90 </subject_mark>
</mark>
<mark>
<subject_name> maths </subject_name>
<subject_mark> 80 </subject_mark>
</mark>
</marks>
<marks>
<Serial>2</Serial>
<mark>
<subject_name> english </subject_name>
<subject_mark> 90 </subject_mark>