Merge duplicate values on a basic table (Alteryx version 2020.2)

[AMCM0806]

Hi all, 

The only solution I found on this issue I am unable to view due to the solution being on a newer version of Alteryx than I currently have. 

I have a sample dataset with duplicate values and would like to output a basic table merging those duplicate rows. 

Current output of the basic table looks like this image below.

desired basic table output would be to merge the first column (or however many columns) that have duplicate values. 

Thank you in advance for your help!

[ShankerV · Accepted solution]

Hi @AMCM0806 

The below article/blog will help you to get the desired output. It is similar to your requirement.

https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-1/bc-p/9757...

Note: Use sort tool on the column region and then use the steps in the blog.

Many thanks

Shanker V

[AMCM0806]

Wow! Thank you for sharing! This is exactly what I needed and solved the issue!