Hope it will solve your problem as per my understanding.
DECLARE @XML XML='<documentelement>
<test><c0>manas</c0><c1>100</c1><c2>20</c2><c3>33</c3><c4>54</c4><c5>65</c5><c6>78</c6></test>
<test><c0>manasi</c0><c1>101</c1><c2>25</c2><c3>76</c3><c4>90</c4><c5>12</c5><c6>74</c6></test>
<test><c0>mani</c0><c1>115</c1><c2>29</c2><c3>56</c3><c4>11</c4><c5>95</c5><c6>78</c6></test>
</documentelement>'
Select Column1= x.value('c0[1]','varchar(100)') + ' '+ x.value('c1[1]','varchar(100)')+' ' +x.value('c2[1]','varchar(100)') +' '+x.value('c3[1]','varchar(100)'),
Column2= x.value('c0[1]','varchar(100)') + ' '+ x.value('c4[1]','varchar(100)')+' ' +x.value('c5[1]','varchar(100)') +' '+x.value('c6[1]','varchar(100)')
from @XML.nodes('/DocumentElement/test') e(x)