Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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