Skip to content
Prev 170573 / 398502 Next

MDS with ranking data (and transformation)

Charles C. Berry wrote:
Hi Chuck - thx - but I have trouble geting further. I think I need "rank"
not "sort" - but this still doesnet solve my conundrum.

I have data like this
v1,v2,v3
nameA,nameB,nameC
nameB,nameA,nameC
nameB,nameA,nameC
nameA,nameC,nameB

And I would like to transform to this
nameA,nameB,nameC
v1,v2,v3,
v2,v1,v3
v2,v1,v3
v1,v3,v2

Hope this makes sense?

Thx again!
Andreas