Grouping/copy and pasting data

Question

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.

FY2022_XML_SF133_Department_of_the_Interior.xlsx

Felipe_Ribeir0 · Answer

Hi @gdorwart

so like this?

Groupingcopy and pasting data.yxzp

gdorwart · Answer

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

Felipe_Ribeir0 · Answer

Hi @gdorwart

Like this?

Groupingcopy and pasting data.yxmd