Hi. In the following example, how do I combine the Display value by a semi-colon separator into one field when the Item value changes?
Example:
Original Data
Results
Attached is the sample data set. Any assistance is appreciated. Thanks.
EZ Sample 10042024.xlsx (10.2 KB)