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

General Discussions

Discuss any topics that are not product-specific here.

Transforming data

MrLawrence
5 - Atom

Hello, 

 

I apologise if this is the wrong place to post but I need assistance. 

 

I have a set of data (this is a small sample)

 

MrLawrence_0-1681743269466.png

 

currently at this stage, I need to transform it to look like;

 

MrLawrence_1-1681743310617.png

everything I have tried hasn't worked. 

 

Please can someone provide some guidance? I have managed this in excel but the amount of formulas to pull data in nearly crashed it. 

 

1 REPLY 1
binuacs
21 - Polaris

@MrLawrence Would you be able to provide some sample data and expected output?

Labels
Top Solution Authors