Multi Row Formula Doubts

[Ajay_Tiwari_2020]

I Have huge data to fill the nulll values when the accounts# is same witth the same client and country in the excel file.

Please find the below format which is want to fill the same.

Account#      Client     Country     Amt
1                   A             AA            10
2                   B            BB            20
1                  Null         Null           30
2                  Null         Null           40
3                  C            CC            50
3                  Null        Null           60
3                  Null        Null           55

It will be really good if anyone can help me the same.

Thank you

Ajay

[atcodedog05 · Accepted solution]

Hi @Ajay_Tiwari_2020 

You can achieve it with use of 2 multi-row formula tool.

Workflow:

Hope this helps : )

[Luke_C]

Hi @Ajay_Tiwari_2020 

Try something like this:

1. Transpose the data, sort it,
2. Use the multirow tool to fill in nulls
3. Cross tab back to the original format

[atcodedog05]

Happy to help : ) @Ajay_Tiwari_2020 

Cheers and have a nice day!

[Ajay_Tiwari_2020]

@ atcodedog05

Thank you so much It really works!!!!