Shift down and then to the right
 

I have sets of data in blocks of three vertical cells (A1:A3, B1:B3, C1:C3,
A4:A6, B4:B6...................). I need to shift them as many blocks as the
user indicates starting from left to right and then when column C is reached
down below to the next available row, something like this

Original order

A1: Red B1: Blue C1: Pink
A2: Red B2: Blue C2: Pink
A3: Red B3: Blue C3: Pink
A4: Black B1: White C4: Yellow
A5: Black B1: White C5: Yellow
A6: Black B1: White C6: Yellow


If they choose to shift 1 (block of data) it'll look like this

B1: Red C1: Blue
B2: Red C2: Blue
B3: Red C3: Blue
A4: Pink B4: Black C4: White
A5: Pink B5: Black C5: White
A6: Pink B6: Black C6: White
A7: Yellow
A8: Yellow
A9: Yellow


Thanks in advance

Shift down and then to the right
 

Check your other post.

LuisE wrote:

I have sets of data in blocks of three vertical cells (A1:A3, B1:B3, C1:C3,
A4:A6, B4:B6...................). I need to shift them as many blocks as the
user indicates starting from left to right and then when column C is reached
down below to the next available row, something like this

Original order

A1: Red B1: Blue C1: Pink
A2: Red B2: Blue C2: Pink
A3: Red B3: Blue C3: Pink
A4: Black B1: White C4: Yellow
A5: Black B1: White C5: Yellow
A6: Black B1: White C6: Yellow

If they choose to shift 1 (block of data) it'll look like this

B1: Red C1: Blue
B2: Red C2: Blue
B3: Red C3: Blue
A4: Pink B4: Black C4: White
A5: Pink B5: Black C5: White
A6: Pink B6: Black C6: White
A7: Yellow
A8: Yellow
A9: Yellow

Thanks in advance

--

Dave Peterson