Merging records in multiple rows into single record

[jmedidi]

not sure if the solution already exists. Trying to merge records in different rows into single record. Something like below:

Existing	Field1	Field2	Field3
	9/27/2021	Text1	XX-PP-AAAA
	Dummy1	Text2	abc@gmail.com
		Text3	8987833
			Hello World
	Field1	Field2	Field 3
Expected Output	9/27/2021 Dummy1	Text1 Text2 Text3	XX-PP-AAAA abc@gmail.com 8987833 Hello World

[atcodedog05 · Accepted solution]

Hi @jmedidi 

You can use summarize tool concat method for this.

Workflow:

Hope this helps : )

[jmedidi]

Thanks for the reply.