Separate out merged cells by row lines in alteryx without duplicating data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
VinithaNair
7 - Meteor
‎04-22-2024
04:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
Desired output:
Labels:
- Labels:
1 REPLY 1
‎04-22-2024
04:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
