Merge multiple rows into one row

sonseeahray

I have 4 data sets I am needing to merge into a single row based on the tracking #. Each data set contains a field or fields that have different data I need to compile into one record. Below is an example of what I have and what I am attempting to do. I think I am over complicating my attempt to merge.

This is what my messy solution looks like...

BrandonB

The summarize tool has some functionality that can help with this. You can group by the field that you want one row for each value, and then the others you can use a combination of “first” if you just want the first value or “concatenate” if you want all of the values put into one cell for each group of values in that column. You can also use functions like max or min if you need the largest or smallest values if there are various different ones.