Report format remove duplicates and grouping

[neeleshapatil1]

Hi

Can someone please confirm how to achieve output as shown in attached image in excel through Alteryx? 

Like Segment/Category columns show only unique values and don't repeat on each line after grouping. tried with summarize tool but not working correctly. Appreciate your inputs here

[mborriero · Accepted solution]

Hi @neeleshapatil1, that is possible however you will need to use a multi-row formula for each field you want unique value, and group the data at the higher level.

See the workflow attached and let me know if you need any clarifications.

[NicolasLedesma]

I'm unable to check the WF could u specify what you have done in it ?