How to move data from one row and column, to another

Hello,

i would like to ask if there's a tool or a formula to take data from one row and then move it to a different row and column?

For example, i would like to take the data that's in column B, row 20 and move it to column C row 19.

A B C

250024000	Other Liabilities
	50-0000-0030435	840	716	717,00	12,85	12,85	43.864,00

Any ideas on how to do that are highly appreciated.

Thank you,

Workflow

Tips and Tricks

Accepted answers

joshbennett

@Darko

In that case, you can just update the Multi-Row Formula expression to the following (but leaving everything else the same):

if isempty([C]) or isnull([C]) then [Row+1:B] else [C] endif

Let me know if that does the trick for you.

All comments

DavidP

The multi-row formula can do this. Have a look at the example in the tool palette

grazitti_sapna

Hi @Darko,

Based on a certain condition you can make use of the Multi-row formula to update the rows as per your requirement. You can also select the column that you want to update.

For more details on how to make use of multi-row formula please go through the below link:

https://community.alteryx.com/t5/Alteryx-Designer/Tool-Mastery-Multi-Row-Formula/ta-p/86603

joshbennett

Hi @Darko - here is an example of a formula you can use in the Multi-Row Formula tool suggested by @DavidP that would achieve the desired result for your scenario. If you wanted to remove the value from the original record after transferring it to the new record, you could just use another Multi-Row Formula to clear it out.

Hope that helps! Workflow attached for reference.

Re How to move data from one row and column, to another.yxmd

Darko

That's really helpful, but i may have explained my problem poorly. I basically need to fill every empty space (there are several) in column C with data from column B +1 row.

So what i'd need is a formula that would work on the whole column C and not just for a certain row (19 in the example).

joshbennett

@Darko

In that case, you can just update the Multi-Row Formula expression to the following (but leaving everything else the same):

if isempty([C]) or isnull([C]) then [Row+1:B] else [C] endif

Let me know if that does the trick for you.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703