<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:template match="/">
		<resultroot>
			<xsl:for-each select="root/guid/item/guid">
				<xsl:variable name="varGUID" select="."/>
					<groupedguid>
						<guid><xsl:value-of select="$varGUID"/></guid>
						<xsl:for-each select="../../../header/item[ref_guid=$varGUID]">
							<headernumber><xsl:value-of select="headernumber"/></headernumber>
						</xsl:for-each>
						<xsl:for-each select="../../../salesinfo/item[ref_guid=$varGUID]">
							<salesunit><xsl:value-of select="sales"/></salesunit>
						</xsl:for-each>
						<xsl:for-each select="../../../text/item[ref_guid=$varGUID]">
							<salesunit><xsl:value-of select="text"/></salesunit>
						</xsl:for-each>
						<!-- additonal sets of data selected with additional for-each elements -->

					</groupedguid>
				</xsl:for-each>
		</resultroot>
	</xsl:template>
</xsl:stylesheet>