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