Transpose Rows to Column transformation

[vimalmanavalan]

Hello all,

I'm investigating on converting rows to column transformation as given below.

I have referred serval blog on row to column conversion couldn't manage to get any good solution yet .

Please let me know how can we achieve below output as shown .

[Lisa_P]

Is this to load the data to create the Output or just present it?  If you just want to present it this way you can create a pivot table in the sheet view that contains class and Division as dimensions and then use the Only(Division) as a measure.

 

[Saravanan_Desingh · Accepted solution]

Try this,

tab1:
Generic
LOAD class, 'row'&AutoNumber(Division) As row, Division;
LOAD * INLINE [
    class, Division
    10, A
    10, B
    10, C
    8, A
    8, B
    8, C
    8, D
    5, A
    5, B
    6, A
    7, A
    7, B
    9, A
];

[Saravanan_Desingh]

Output:

[vimalthehero]

Thanks, its exactly the one I'm looking for 🙂

[Saravanan_Desingh]

you welcome