Hierarchy Reformat

[Processcreator]

Hi All,

appreciate any help in advance. I have a company hierarchy file that I am trying to reformat. The data looks like this

Company     Business Unit.    Account

ABC

                   North America.       123

                                                  345

                   South America

                                                  567

I'm trying to essentially get it to fill down. Using a multi row formula I have been able to get it to look like this.

Company     Business Unit.    Account

ABC

ABC            North America.       123

 ABC           North America        345

 ABC           South America.      345

 ABC           South America.       567

The problem is instance such as the third line. It's filling down since the cell is blank but 345 shouldn't be on a South America line. Any ideas on how to fix?

[atcodedog05]

Hi @Processcreator 

Here is how you can do it. You can use multi-row formula to fill up to down.

Workflow:

Hope this helps : )

[RolandSchubert]

Hi @Processcreator ,

I think, a group by in the last Multi Row Formula tool could solve the problem. 

Best,

Roland