Hey guys, I'm struggling with this operation in Alteryx and I would be very grateful if someone could help me. I tried to use formula, multi-field formula, multi-row formula but couldn't make it so far.
It is just a meaningless example below, but I want to duplicate columns from A to C, giving them a new name (in the example newA, newB and newC) and shifting them down like this:
newA = A shifted down by 0 cell
newB = B shifted down by 1 cell
newC = C shifted down by 2 cells
and so on...
Also, where might be Blanks or Nulls in consequence of the shifting, I want to put a 0.
Before
| Name | A | B | C |
| Name1 | 1 | 6 | 11 |
| Name2 | 2 | 7 | 12 |
| Name3 | 3 | 8 | 13 |
| Name4 | 4 | 9 | 14 |
| Name5 | 5 | 10 | 15 |
After
| Name | A | B | C | newA | newB | newC |
| Name1 | 1 | 6 | 11 | 1 | 0 | 0 |
| Name2 | 2 | 7 | 12 | 2 | 6 | 0 |
| Name3 | 3 | 8 | 13 | 3 | 7 | 11 |
| Name4 | 4 | 9 | 14 | 4 | 8 | 12 |
| Name5 | 5 | 10 | 15 | 5 | 9 | 13 |
