I need to group the following data which i get in the below format from the xml.I am using XSLT 1.0

Existing data

PO# Program Pattern Style Color Width Size
100 FLORENTINE MIDGE 74199 BLACK M 5
100 FLORENTINE MIDGE 74199 BLACK M 5
100 FLORENTINE MIDGE1 74100 BLACK M 5
100 FLORENTINE1 MIDGE1 74100 BLACK M 5
101 FLORENTINE1 MIDGE1 74101 BLACK M 5

Expected Result:
PO# Program Pattern Style Color Width Size
100 FLORENTINE MIDGE 74199 BLACK M 5
                             74199 BLACK M 5
                    MIDGE1 74100 BLACK M 5
                             74100 BLACK M 5
101 FLORENTINE1 MIDGE1 74101 BLACK M 5

I tried grouping in many ways but still could not get a solution to this.<b>Specially making the column fields as empty.</b>

You say you've tried many ways, but you don't say what you tried.

For XSLT 2.0, use xsl:for-each-group. That should make this problem very easy.

For XSLT 1.0, use Muenchian grouping. You can find that covered in most textbooks, or google for Jeni Tennison's tutorial on the subject. It's seems very tricky at first, but you get the hang of it.

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

Can you post the input in XML format?

--
  Martin Honnen
  Microsoft MVP - XML