Multiple columns Pivoting : How to get multiple pivot Names and values in once ?

Dear all,

I've been playing with table pivoting for a long time but in other apps than Pipeline. What I often use and need is a multiple columns pivoting. For example :

ABCDE
11.110YAA
22.120YAA
11.130NAA
22.140NBB
11.150YBB
22.160YCC

would give as an output of the pivot :

ABY+AAN+AAY+BBN+BBY+CC
11.110305060
22.12040

I tried the Pivot data component trying to put more than one Pivot Name and Pivot value but it does not work. Has anybody some experience with multi-column pivoting in Pipeline that could help ?

Thanks,

Jonathan.