how to transform rows to column

[Anonymous]

Hello everyone,

I have an issue at hand i am trying to transpose rows to columns this is what i have

PROFILE;FIELD;EDITABLE;READABLE
AA;BA;TRUE;FALSE
AA;BB;TRUE;TRUE
AB;BA;FALSE;TRUE
AB;BB;TRUE;FALSE
 
I want to achieve this

	AA	AA	AB	AB
	EDITABLE	READABLE	EDITABLE	READABLE
BA	TRUE	FALSE	FALSE	TRUE
BB	TRUE	TRUE	TRUE	FALSE

can anyone help please??

[Anonymous]

Utilisé le composant tsplitRow

[Anonymous]

Merci pour l'aide. j'ai pu trouver un moyen avec tpivottocolumndelimited

[Anonymous]

You can use the tNormalize or tDenormalize.

[Anonymous]

You can use the tNormalize or tDenormalize.
they allow you to transform row to column or column to row.
Otherwise  if you use TOS , get the tUnpivotrow on exchange.