Merging Rowset in XML document

[ateltaop]

I have follwoing XML with me with multiple Rowset in it. I want to merge all Rowset into one. SO can you please help how would I do that using XSLT or with any other method?Current XML:\[code\]<?xml version="1.0" encoding="utf-8"?><Rowsets DateCreated="2012-07-17T11:57:07" EndDate="2012-07-17T11:57:07" StartDate="2012-07-17T10:57:07" Version="12.0.12 Build(9)"><Rowset> <Columns> <Column Description="Name" MaxRange="1" MinRange="0" Name="Name" SQLDataType="12" SourceColumn="Name"/> <Column Description="City" MaxRange="1" MinRange="0" Name="City" SQLDataType="4" SourceColumn="City"/> <Column Description="Phone" MaxRange="1" MinRange="0" Name="Phone" SQLDataType="12" SourceColumn="Phone"/> </Columns> <Row> <Name>Philip</Name> <City>London</City> <Phone>123</Phone> </Row> <Row> <Name>Derek</Name> <City>Seattle</City> <Phone>500</Phone> </Row> <Row> <Name>Bruke</Name> <City>LosAngeles</City> <Phone>600</Phone> </Row> <Rowset> <Columns> <Column Description="Name" MaxRange="1" MinRange="0" Name="Name" SQLDataType="12" SourceColumn="Name"/> <Column Description="City" MaxRange="1" MinRange="0" Name="City" SQLDataType="4" SourceColumn="City"/> <Column Description="Phone" MaxRange="1" MinRange="0" Name="Phone" SQLDataType="12" SourceColumn="Phone"/> </Columns> <Row> <Name>Yang</Name> <City>SFO</City> <Phone>1233</Phone> </Row> <Row> <Name>Cristina</Name> <City>SanJose</City> <Phone>890</Phone> </Row> </Rowset> <Rowset> <Columns> <Column Description="Name" MaxRange="1" MinRange="0" Name="Name" SQLDataType="12" SourceColumn="Name"/> <Column Description="City" MaxRange="1" MinRange="0" Name="City" SQLDataType="4" SourceColumn="City"/> <Column Description="Phone" MaxRange="1" MinRange="0" Name="Phone" SQLDataType="12" SourceColumn="Phone"/> </Columns> <Row> <Name>Meredith</Name> <City>Sunnyvale</City> <Phone>788</Phone> </Row> <Row> <Name>Grey</Name> <City>MountainView</City> <Phone>456</Phone> </Row> <Row> <Name>Torrence</Name> <City>SAntaClara</City> <Phone>432</Phone> </Row> </Rowset></Rowset></Rowsets>\[/code\]Output XML that is Needed:\[code\]<?xml version="1.0" encoding="utf-8"?><Rowsets DateCreated="2012-07-17T11:57:07" EndDate="2012-07-17T11:57:07" StartDate="2012-07-17T10:57:07" Version="12.0.12 Build(9)"> <Rowset> <Row> <Name>Philip</Name> <City>London</City> <Phone>123</Phone> </Row> <Row> <Name>Derek</Name> <City>Seattle</City> <Phone>500</Phone> </Row> <Row> <Name>Bruke</Name> <City>LosAngeles</City> <Phone>600</Phone> </Row> <Row> <Name>Yang</Name> <City>SFO</City> <Phone>1233</Phone> </Row> <Row> <Name>Cristina</Name> <City>SanJose</City> <Phone>890</Phone> </Row> <Row> <Name>Meredith</Name> <City>Sunnyvale</City> <Phone>788</Phone> </Row> <Row> <Name>Grey</Name> <City>MountainView</City> <Phone>456</Phone> </Row> <Row> <Name>Torrence</Name> <City>SAntaClara</City> <Phone>432</Phone> </Row> </Rowset></Rowsets>\[/code\]So can you guys plz help me how can I achieve this?Thanks !