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

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/975775#M3195

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

Many thanks

Shanker V