Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!
Free Trial

Alteryx Designer Desktop Discussions

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

moving nulls into the same column as above

NY2BOS
7 - Meteor

Hello all my data looks like this 

 

CityName MinMin ValueName MaxMax Value
New YorkPaper1.2  
New York  Metal2.2
BostonMetal1.1  
Boston  Paper3.2

 

But want it to look like this

 

CityName MinMin ValueName MaxMax Value
New YorkPaper1.2Metal2.2
BostonMetal1.1Paper3.2
2 REPLIES 2
Bren_Spill
12 - Quasar
12 - Quasar

@NY2BOS - give this a shot.

Deano478
12 - Quasar

Hey @NY2BOS heres an approach you could take

Labels
Top Solution Authors