Re: transforming XML to XML with XSLT 1.0

Your requested output format didn't appear to group the elements  with
the same aid by anything other than the top level element so it's not
clear how you want multiple aid values reporting, similarly  it's not
clear what you are supposed to do if the aid values are the same but the
type or version numbers are different.

Basically assuming that aid, type and version are the key that you want
to group on, you want to use muenchian grouping with a key of
match="Row" use="concat(@AID,':',@GROUP_TYPE,':',@GROUP_VERSION)

and then, for the nodes in each group do the for-each that I posted last
time.