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%

Moving a row of data from a specified point

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%

Workflow

Datasets

Input

Output

Transformation

Accepted answers

CoG

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...)

Sample Workflow.yxmd

All comments

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.

CoG

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...)

Sample Workflow.yxmd

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

Community_1214986.yxmd

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703