Data hierarchy

[Navya08]

Can someone help me to get desired output i tried building hr hierarchy but got confused to obtain the output,

i have HR  data

i want the manager wise output.

for example:

the employees reporting to Mark Z

and Rich L.

as attached in the screenshot.

also can we leave one tab in the output after one manager name to make it look more neat?

please help.

[binuacs]

@Navya08 Cross tab your input data 

[Navya08]

thank you for the help.

but the problem here is i have 50000 of data. And i just need data for 10-12 managers

So if i just need for mark and rich ?

what would be the approach,

so that i can add on names for which i require the their direct reportees

[binuacs]

@Navya08 Add a filter tool and filter out the Managers you want

[Navya08]

It works. Thank you!!