Pull bottom row data and pull up to first row if they share same value

[YRichardson12]

I have data that has the same record number but their values differ based on when they come in. What is the easiest way to pull this data up if they share the same number? See attached example for reference. TIA!

[jenniferpearce · Accepted solution]

You can use a summarize tool and group by your first 2 fields and then concatenate the 3 that you want to combine.

[jenniferpearce]

If you need that original column.

[Raj · Accepted solution]

@YRichardson12 
Another way of doing this
find the workflow attached.

[YRichardson12]

Thank you, all! This has been very helpful!