Hi I have a table like this (in XML format)

No EntityID Filed Data VarSeq
---------------------------------------
1 88 Name abc 1
2 88 Ph 123 2
3 77 Name xyz 1
4 77 Ph 456 2


I would like to display data like this

Seq Name Ph
----------------------
1 abc 123
2 xyz 456

I am very appreciate if any body provides XSLT code for this scenario

Waiting for your reply

Thanks & Regards
Vijay

This is a grouping problem: you need to group the rows that have the same EntityID. For XSLT 1.0 look up Muenchian grouping (e.g. at www.jenitennison.com), for 2.0 use <xsl:for-each-group>.

Then when processing each group, you output a row that contains the Name and the Ph, which can be obtained using fairly simple path expressions.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference