Using Normalizer T/R we can achieve this; Horizontal Pivoting i.e Converting Single horizontal record into Multiple vertical records. Even reverse logic i.e; Vertical Pivoting also possible using the Normalizer T/R.
We need to use NORMALIZER transformation to convert single
row into multiple rows.
Ex: NAME SALES QUARTERCID KT_NRMSALES_ID
Books 10 &nb sp; 1 1
Books 20 2 2
Books & nbsp; 30 3 3
TO --> NAME Q1 Q2 Q3
Movies 40 30  ; 70
Books 10 20 30
Furniture 20& nbsp; 10 90
And we need to use aggregator transformation to do reverse
In this we have to use any of the aggregate function
SUM/MIN/MAX and then decode to get the particular quarter