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.

Grouping/copy and pasting data

gdorwart
7 - Meteor

Hello,

 

I am attempting to create a formula that can take data and copy and paste it in front of other rows of data. I need to take rows C1-C6 and copy and paste them in front of rows A8-11, A13-21, A23-25, A27-A33, and A35-A38. Obviously, I could this quickly in excel but I need to do this across thousands of rows which would take hours upon hours to do manually. Any help with this would be much appreciated! The original excel is attached as well. 

 

 

SFFAs capture 1.PNG

 

 

3 REPLIES 3
Felipe_Ribeir0
16 - Nebula

Hi @gdorwart 

 

Like this?

 

Felipe_Ribeir0_0-1672789161396.png

 

gdorwart
7 - Meteor

Not quite, so more like this where everything from up top gets pushed over to the left of the account numbers.Alteryx problem 2.PNG

Felipe_Ribeir0
16 - Nebula

Hi @gdorwart 

 

so like this?

 

Felipe_Ribeir0_0-1672869895317.png

 

Labels
Top Solution Authors