Multi-Row Formula

[Neffri]

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.

 

[atcodedog05 · Accepted solution]

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

[mceleavey · Accepted solution]

Hi @Neffri ,

I wrote a tool to do this. See attached.

Hope this helps,

M.

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

M.

[mceleavey]