Re: Re-arranging an XML file

Dear Group,

Further to my mail of Date: Tue, 13 Jan 2009: I am still struggling
with this one. Here is an adaptation of a real-world example:

<?xml version="1.0" encoding="UTF-8"?>
<wc:COLLECTION xmlns:wc="http://www.ptc.com/infoengine/1.0">
<DeletedArtists NAME="DeletedArtists" TYPE="Unknown" STATUS="0">
</DeletedArtists>
<AddedArtists NAME="AddedArtists" TYPE="Unknown" STATUS="0">
<Artist>
    <LastChangedBy>Mike</LastChangedBy>
    <Number>0000000015</Number>
    <Name>Bob Dylan</Name>
</Artist>
<Artist>
    <LastChangedBy>Mike</LastChangedBy>
    <Number>0000000016</Number>
    <Name>Bonnie Tyler</Name>
</Artist>
</AddedArtists>
<DeletedAlbums NAME="DeletedAlbums" TYPE="Unknown" STATUS="0">
</DeletedAlbums>
<AddedAlbums NAME="AddedAlbums" TYPE="Unknown" STATUS="0">
<Album>
    <ArtistNumber>0000000015</ArtistNumber>
    <AlbumNumber>0000000010</AlbumNumber>
    <AlbumName>Blood on the Tracks</AlbumName>
</Album>
<Album>
    <ArtistNumber>0000000015</ArtistNumber>
    <AlbumNumber>0000000011</AlbumNumber>
    <AlbumName>Empire Burlesque</AlbumName>
</Album>
<Album>
    <ArtistNumber>0000000016</ArtistNumber>
    <AlbumNumber>0000000020</AlbumNumber>
    <AlbumName>Hide Your Heart</AlbumName>
</Album>
</AddedAlbums>
</wc:COLLECTION>

How can I turn that into something like this using XSL?

<AddedAlbums>
  <Album>
    <Name>Bob Dylan</Name>
    <AlbumName>Blood on the Tracks</AlbumName>
  </Album>
  <Album>
    <Name>Bob Dylan</Name>
    <AlbumName>Empire Burlesque</AlbumName>
  </Album>
  <Album>
    <Name>Bonnie Tyler</Name>
    <AlbumName>Hide Your Heart</AlbumName>
  </Album>
</AddedAlbums>

Many thanks,

Mike in SA
ps: Please don't think that I'm a great fan of Bonnie Tyler! I don't
think I could even name one of her songs!
M.