Moving a row of data from a specified point

[RNSEG]

I have this set of data here below. What i would like to do is move the data from row 4 column 4 (bolded number) to the right by one column each. How do i go on about this? I was thinking of use the very last cell being [Null] and use IF formulas to move but not sure how to write it. 

Opening Shares	Opening Net NAV Per Share	Share Subs/Reds Transfers	Share Consolidation	Closing Shares	Closing Net NAV Per Share	Closing Value	Net Return
2,390.92	702.04	-	(2,390.92)	-	-	-	-2.54%
24,872.75	713.39	(11,826.74)	-	13,046.01	691.06	9,015,629.73	-3.13%
-	-	-	2,368.03	2,368.03	690.80	1,635,823.57	-2.52%
6,595.65	713.39	-	6,595.65	691.06	4,558,019.83	-3.13%	[null]

Desired output: 

Opening Shares	Opening Net NAV Per Share	Share Subs/Reds Transfers	Share Consolidation	Closing Shares	Closing Net NAV Per Share	Closing Value	Net Return
2,390.92	702.04	-	(2,390.92)	-	-	-	-2.54%
24,872.75	713.39	(11,826.74)	-	13,046.01	691.06	9,015,629.73	-3.13%
-	-	-	2,368.03	2,368.03	690.80	1,635,823.57	-2.52%
6,595.65	713.39	-	-	6,595.65	691.06	4,558,019.83	-3.13%

[RNSEG]

I thought about doing this. IF IsNull([Net Return]) THEN [Closing Value] ELSE [Net Return] ENDIF. Which moves the -3.13% to the right but the 3.13% still remains in the Closing Value column so I can't use the same formula to move it to the right again. 

[AndrewDMerrill · Accepted solution]

Here is one solution that should work for your use case (Just make sure that the columns are renamed appropriately with the Select Tool; this caused me quite the headache...)

[Yoshiro_Fujimori]

Hi @RNSEG 

I hope this works for you.

Workflow

Multi-Row Formula 2

IF [RowNo] = 4 AND [ColNo] = 4 THEN "-"
ELSEIF [RowNo] = 4 AND [ColNo] > 4 THEN [Row-1:Value]
ELSE [Value]
ENDIF

[RNSEG]

Thank you for your help! This method is very simple and straightforward. I will stick to this. 

[RNSEG]

Thank you for sharing - taking a deeper look at this. My data table in the question is only a minor part of the full data set and believe what you shared is specifically for the 4 rows of data. However I will look into this way and see if i can apply this. 

Thank you for your help!