Merge two row into one row

[terrellchong]

Hi Alteryx Community,

How do I solve this problem in alteryx?

Name	Method	Date	Methods
A	1	2020-5-8	[Null]
A	[Null]	2020-5-8	3

I want to change it into this.

Name	Method	Date	Methods
A	1	2020-5-8	3

How should I proceed?

[DavidP]

Here's one way

[terrellchong]

I'm sorry actually the data looks like this.

 So if I use summarize, and max, it will go to the 3,3 instead on 1, 3.

Is there any method to go around?

[JosephSerpis · Accepted solution]

Hi @terrellchong I mocked up a worklfow let me know what you think?

[terrellchong]

Yes! This is exactly what I am looking for. Mind if you tell me what you did with the multi-row formula?

[JosephSerpis]

Hi @terrellchong I just slightly revised the multi formula tool and attached to my previous message but essentially this checking to see if the column name and value are the same if they are it will make the second row empty so this removed in the filter.