Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Desired Layout of Data Set

dbrown94
5 - Atom

Hello- I have a dataset (pictured) that is currently laid out as per the 'Current' section- I want to use Alteryx to achieve the 'Required' layout. What is the easiest way to do this? (file attached for reference also)

 

 

Screenshot 2025-05-28 101016.png

 

3 REPLIES 3
abacon
12 - Quasar

Is the No. of emails section for Client C supposed to have a colon or do they not have it sometimes?

dbrown94
5 - Atom

Thanks for pointing this out- it's expected that they will always have a colon! I have updated this in my data set 

 

abacon
12 - Quasar

Then here you go, this gets the output you want.

 

Bacon

Labels
Top Solution Authors