Hello,
I am trying to find a solution to merge multiple rows into one row.
Input | |
CN | Item |
A | ABC123 |
A | ABC456 |
B | ABC789 |
B | ABC789 |
C | ABC012 |
D | ABC001 |
Desired Output | |
CN | Item |
A | ABC123, ABC456 |
B | ABC789, ABC789 |
C | ABC012 |
D | ABC001 |
any help will greatly be appreciated.
Solved! Go to Solution.
Hi @AJ-CH
Use the Summarize tool, grouping by CN field and using String concatenation on the Item field.
Cheers,
@Thableaus, thanks for quick solution.. it worked.. 🙂
User | Count |
---|---|
19 | |
15 | |
15 | |
9 | |
8 |