Hello
I need final data that contains multiple rows and columns of information for the same user. Each column contains different values, but some columns, such as name, phone, and email, may have duplicate values across multiple rows.
Attached Excel File contain, input and desired output sample.
Example: This is my final outcome from the workflow.
How I want it in my result (please ref: following Image---------------------------------(checkout atached excel file) ?
This is my snippet workflow:
@awanishyadavv
How about using the Concatenate feature in the Summarize Tool?
@Qiu It will append all the fields into one cell for any column, which is not the requirement.
Final output has to be as stated in the image.
User | Count |
---|---|
76 | |
58 | |
53 | |
47 | |
38 |