Tip : Single Row normalize example in PDI

This post is written based on a thread from community forum .

(http://forums.pentaho.com/showthread.php?187160-Identify-duplicate-column-value-from-single-row)

USE CASE : 

EXPECTED OUTPUT 

Transformation Design :

Sample KTR file download :  Click HERE

References :
1)  http://wiki.pentaho.com/display/EAI/Row+Normaliser
2) http://wiki.pentaho.com/display/EAI/Row+denormaliser
3) http://rpbouman.blogspot.in/2012/03/generic-normalizer-step-for-kettle.html
4) http://stackoverflow.com/questions/15232294/converting-row-columns-to-rows-with-pentaho-kettle-pdi