In a table you can concatenate field values or row values.
Concatenating field values
Learn more about concatenating field values from this blog.
Concatenating row values
Download the script tool from here. This tool is based on a python script that takes an input table, selects a row(s) based on a field value, and concatenates the row values of any other specified field. This tool does not create a new output, but updates the input data.
Example of using Concatenating Row Values tool
Usually, in field sampling data a single point (e.g. the center or the intersection of a quadrant) is linked to an area in the field, and the data recorded for each species (grass/shrubs vegetation) within the quadrant is added as a separate entry linked to the same point as shown below:
This data has multiple records for the same center point of the quadrants. In such cases, if you want to concatenate the vegetation values for the same quadrant you can run the Concatenate Row Values tool (as shown below):
After concatenating the row values, you don’t need all the multiple points because one point has all the information you need (the All_Vegetation field). The Delete Identical tool can then be used to delete all but one of the multiple points (as shown below):
This workflow is shown below in a simple model:
Since both the tools modify the input, creating a backup copy of the input is strongly recommended.