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