Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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