I am attaching the excel for your reference. It contains sample data and UI mockup. Thanks!
sample.xlsx 17.5 K
Please look at script code below:
LOAD [Emp ID],
[Manager ID] as MANAGER
(ooxml, embedded labels, table is Sheet1);
Hierarchy ([Emp ID], [MANAGER], [Name], [Manager Name], [Name], Hierarchy,,MDepth)
Waiting for some quick suggestions!!