Show full path to all tags in xml (xslt newbie)

[Critcho]

I have a stack of xml documents (total size about 1MB!), I would like to get a listing of all the tags, in node1.node2.tag format, value would be nice too. I have done a few basic xsl transforms before, but from what I have seen, it will only show the final tag name.

e.g.

<xsl:for-each select="Node1/Node2/Node3/*">
		<tr>
			<td><xsl:value-of select="Tag"/></td>
		</tr>
</xsl:for-each>

Will produce

Tag1
Tag2
Tag3

Whereas I want

Node1.Node2.Node3.Tag1
Node1.Node2.Node3.Tag2
Node1.Node2.Node3.Tag2

The branch depth will vary, anywhere from tags in the top node to maybe 10 nodes deep.
E.g.

Node1.Tag1
Node1.Tag2
Node1.Node2.Tag3
Node1.Node2.Tag4
Node1.Node2.Node3.Tag5
etc

Does anyone know a method for this? Perhaps xslt is not the correct engine.

Thanks for your help,
Cheers,
Critcho.

 

[Critcho]

Never mind, I started thinking about it too much... so I wrote a macro in XL, looks like it is working fine. Contact me if you want a copy.