Move one column value to a new column in a specific row using a formula

Question

Hi everyone,
wanted to ask one thing that how we can move one column value to a new column in a specific row using a formula.

As you can see this screenshot.
I have three column and I want to move the 'vid-offset' - json_value to a new column. (marked yellow)

I' using this formula but it's not working for me:
if [has_more]="true" then ([JSON_Name] = "vid-offset" AND [JSON_ValueString])
else Null()
endif

Please help me how I can do it.

Thank you

dhrathod · Accepted Answer

Use Multi Row Formula

if [has_more] = "True" and [Row+1:JSON_Name] = "vid-offset" then [Row+1:JSON_valueString] else null() endif