Multi-Row Formula

Hi,
I have a question regarding the Multi-Row tool.

ID	Name	%	Country
1	A	20	US
2	B	30	TW
3	C	50	US
null	null	null	US
null	null	null	US

Where I have nulls I want to take row-1.
Do you know if is it possible to do this not one by one(ID, Name,%).
In my real task I have ~8 column so I would like to avoid writing formula for each of them.

Workflow

Accepted answers

atcodedog05

Hi @Neffri

Here is how you can do it.

Workflow:

1. Use transpose to convert columns to rows.

2. Apply mutli-row formula fill with groupby name (column name)

3. Convert it back to table using crosstab using record id as key.

Hope this helps : )

mutiple mult-row formula.yxmd

mceleavey

Hi @Neffri ,

I wrote a tool to do this. See attached.

Hope this helps,

Autofill.yxzp

All comments

atcodedog05

Hi @Neffri

Here is how you can do it.

Workflow:

1. Use transpose to convert columns to rows.

2. Apply mutli-row formula fill with groupby name (column name)

3. Convert it back to table using crosstab using record id as key.

Hope this helps : )

mutiple mult-row formula.yxmd

mceleavey

Hi @Neffri ,

I wrote a tool to do this. See attached.

Hope this helps,

Autofill.yxzp

Neffri

Thank you !!!

atcodedog05

Happy to help : ) @Neffri

Cheers and have a nice day!

mceleavey

Cheers @atcodedog05 for pointing out a minor bug. That tool uses a Crosstab, which of course loses special characters in the column title. I've fixed this now.

Autofill.yxzp

mceleavey

no problem.gif

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703