Filling in a table with multi-row formula tool

[aarhintz]

I need to go from data in the format of:

C1	C2	C3	C4	C5
a	[Null]	[Null]	[Null]	[Null]
b	[Null]	[Null]	[Null]	[Null]
c	[Null]	[Null]	[Null]	[Null]
d	[Null]	[Null]	[Null]	[Null]
e	[Null]	[Null]	[Null]	[Null]

to:

C1	C2	C3	C4	C5
a	b	c	d	e
b	c	d	e	0
c	d	e	0	0
d	e	0	0	0
e	0	0	0	0

Currently, I can get C2 to fill in properly by using a multi-row formula tool.  However, my actual dataset has roughly 90 rows and 90 columns, so I am looking for a better way than just repeating this a bunch of times.  I think I need to use a batch macro, but I am unsure how to go about using control parameters to update 3 separate values within the multi-row formula tool. 

Thank you for your help!

[ponraj · Accepted solution]

Here is the sample workflow for your case. Hope this is helpful. 

InputWorkflowResults

[ponraj]

@aarhintz, I am curious to know if the solution provided was helpful.