Shift multi columns with Multifield function

Question

Hi, I am new to Alteryx, and have a dataset misaligned to the right by 2 columns, for example like this

I plan to use Multifield function to shift the columns back like following

Given I have 100+ columns to shift left twice back to column C, I can't use simple = formula 100+ times.

This Multifield formula doesn't work [_CurrentField:Column+2].

Can anyone share any insight? Thanks.

IraWatt · Answer

No worries @yfang0! If your happy with that solution make sure to leave a green tick 😄

yfang0 · Answer

It works! Thanks @IraWatt

IraWatt · Answer

Hey @yfang0,

When there's lots of columns transposing is usually a good first idea:

Any questions or issues please ask :)
HTH!
Ira

New Workflow.yxmd