Vlookup Calculation

[hii_amit]

Hi All

Below is my data in excel , i want to create the levels of Line managers

Assuming KCB is at to in hierarchy need the rest of the level for line managers in hierarchy 

formulas used for LM Level calcuation is in attached excel file

thats how they will roll-up

[PraphulSamavedam]

@hii_amit Can you please elaborate on this, its not clear what you want to build. 

Are you looking to build hierarchy of line managers?

[hii_amit]

Yes I want to create hierarchy but from top to bottom. This is called layers in organisation, assume top most is on layer 1 then i want to identify who is on layer 2, 3 and so on

[PraphulSamavedam]

If your expected output is 

Then please find the workflow package attached:

I would like to thank @JordanB for his solution provided in https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Automatically-Remove-all-null-Colums/t...

and @danilang for his suggestion in https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Multi-Row-formula-for-Multiple-columns... 

[PraphulSamavedam]

There was small correction in the iterative macro. Attaching it.
Attaching the snapshots of the macro and the configurations used as requested over the call. I hope you would be able to replicate it.

[hii_amit]

Praphul it seems you have uploaded batch macro instead of iterative macro

[PraphulSamavedam]

Sorry,
Please find the attached iterative macro.

[PraphulSamavedam]

Macro configuration:

[PraphulSamavedam · Accepted solution]

Designation added and details of employees added upfront of output. (As requested over the call).