Hi Everyone, I have Data in this particular format Name IDSerialProduct CodeProd DescriptionAnnie1234AGoodAnnie1234BBadAnnie1234CAverageAnnie1234DfairAnnie1234EFailAnnie1235DfairAnnie1235EFailPeter2231AGoodPeter2231BBadSiri7243UXXSiri7243FYY 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 IDSerialProduct CodeProd DescriptionAnnie1234A,B,C,D,EGood,Bad,Average,fair,FailAnnie1235D,Efair,FailPeter2231A,BGood,BadSiri7243U,FXX,YY

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

Hi Everyone,

I have Data in this particular format

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.

Workflow

Hi @vamsey

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

Workflow:

Hope this helps : )

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

Workflow:

Hope this helps : )

Awesome, Thanks For the help 🙂

Happy to help : ) @vamsey

Cheers and have a nice day!