Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Convert Columns to rows of Grouped Data

sforsandeep
5 - Atom

I have table like this

 

ProjectTeamDomainRiskScoreMilestonePSR
P1234Team1DomainTech324

P4521

Team2Domainport527

 

     

What I am trying to acoomplish is to convert these columns into rows like this

 

ProjectTeamDomainScore TypeScore
P1234Team1DomainTechRiskScore3
P1234Team1DomaintechMlestone2
P1234Team1DomainTechPSR4
P4521Team2DomainPortRiskScire5
P4521Team2DomainPortMilestone2
P4521Team2DomainPortPSR7

i have no idea how to achieve this.. I am very new to alteryx. Please help

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@sforsandeep 
Transpose Tool is what we need here.

Capture1A.PNG

Labels