Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Separate out merged cells by row lines in alteryx without duplicating data

VinithaNair
7 - Meteor

I have a an automated email use case wherein I want to merge duplicate data into a single cell but if the merged data contains multiple rows of data next to it in other columns, those rows should be separated by row lines. The issue and desired result are shown below. Any help would be appreciated. thanks!

 

Input:

 

input.JPG

 

Desired output:

 

desired output.JPG

1 REPLY 1
VinithaNair
7 - Meteor

I have seen a couple of posts suggesting to use text to columns tool but when I try it, the ticker and company gets duplicated in other rows, which we do not want happening.

Labels
Top Solution Authors