ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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
binu_acs
21 - Polaris

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

Labels
Top Solution Authors