In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to clean this data

NY2BOS
7 - Meteor

Hello everyone the data coming in looks like this 

ProductHigh UserValue_highLow UserValue_low
AJames80  
A  John10
BAmy90  
B  Tom20
CNicole40  
C  George10

 

However it should all be in one row and delete the blank row to look like this 

ProductHigh UserValue HighLow UserValue Low
AJames80John10
BAmy 90Tom20
CNicole40George10

 

Thank you

2 REPLIES 2
Bobbyt23
12 - Quasar

You could use a multirow formula for each of the last two columns, like this:

image.png

 

You may need to tweak the first part of the IF statement depending on what is in that cell, blank/space etc.

 

Or a crosstab and transpose:

image.png

aatalai
14 - Magnetar

It can also be done with summarise tool

Labels
Top Solution Authors