Is it possible to combine rows?

I was wondering if this is possible to do in alteryx, I'm new to the software and everything I've tried isn't working. Thanks

Accepted answers

I've attached another way to approach this. I used a Multi-Row formula to create a record ID, then a Summarize tool to return the desired output.

Yes it is possible and various ways to do it.

One possible way would be:

First, filter to split the entity rows.

Then use a join tool set to join by record position

Sample attached doing this

I've attached another way to approach this. I used a Multi-Row formula to create a record ID, then a Summarize tool to return the desired output.

Hi @kdelisi002!
What you're looking for here is the Multi-Row Formula.

Use Multi-Row Formula

Create a New Field

IF Contains([Field1], "Entity") THEN [Field1] + " " + [Row+1:Field1]
ELSE Null()
ENDIF

Create New Field

Use Multi-Row Formula again

IF IsEmpty([Field2]) OR IsNull([Field2]) THEN [Row+1:Field2]
ELSE Null()
ENDIF

Then Use the Filter Tool

[Field1] is not null

I appended a scratch for you.

I'm sure there are easier ways to do that, but that's the fastest way I could think.

Cheers,