How to Group by Based on mutiple variables and crosstab the records in a specific format.

[vamsey]

Hi Everyone,

I have Data in this particular format

Name	ID	Serial	Product Code	Prod Description
Annie	1	234	A	Good
Annie	1	234	B	Bad
Annie	1	234	C	Average
Annie	1	234	D	fair
Annie	1	234	E	Fail
Annie	1	235	D	fair
Annie	1	235	E	Fail
Peter	2	231	A	Good
Peter	2	231	B	Bad
Siri	7	243	U	XX
Siri	7	243	F	YY

I need the data in the format showed below by grouping on Name, ID and Serial followed by product codes and Prod Description with , as separator.

Name	ID	Serial	Product Code	Prod Description
Annie	1	234	A,B,C,D,E	Good,Bad,Average,fair,Fail
Annie	1	235	D,E	fair,Fail
Peter	2	231	A,B	Good,Bad
Siri	7	243	U,F	XX,YY

[atcodedog05 · Accepted solution]

Hi @vamsey 

You can setup summarize tool like below. And you can specify separator at the bottom.

Workflow:

Hope this helps : )

[vamsey]

Awesome, Thanks For the help 🙂

[atcodedog05]

Happy to help : ) @vamsey 

Cheers and have a nice day!