Create multiple levels of hierarchy from just Two column

[iamdijkstra007]

Hello,

I have a two columns of data, need to create multiple levels of hierarchy out of this two columns. The First Column contains manager names and the second column contains the direct reportee of the manager. Within the second column there are managers and they do have the reportees, so basically there are folks in second col who is also a manager and who has reportee in the second column itself.

 

[zero269]

This looks like a pretty comprehensive process. Take a look at these to see if it's what you're looking for...

How to Create an Org Chart in Excel 2023
How to Create an Org Chart in Excel 2022 | ClickUp
It entails using SmartArt for crating an OrgChart Diagram with data you have in Excel.

Leila Gharani covers this topic on her YouTube channel as well if you're familiar with her.
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)

 

[iamdijkstra007]

This looks like a pretty comprehensive process. Take a look at these to see if it's what you're looking for...

How to Create an Org Chart in Excel 2023
How to Create an Org Chart in Excel 2022 | ClickUp
It entails using SmartArt for crating an OrgChart Diagram with data you have in Excel.

Leila Gharani covers this topic on her YouTube channel as well if you're familiar with her.
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)

Thank you for your response, appreciate it. But this solution didn't really solve my problem. I was looking to get hierarchy done using PowerPivot itself.

This looks like a pretty comprehensive process. Take a look at these to see if it's what you're looking for...

How to Create an Org Chart in Excel 2023
How to Create an Org Chart in Excel 2022 | ClickUp
It entails using SmartArt for crating an OrgChart Diagram with data you have in Excel.

Leila Gharani covers this topic on her YouTube channel as well if you're familiar with her.
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)

 

[zero269]

I was looking to get hierarchy done using PowerPivot itself.

Hierarchies in Power Pivot - Microsoft Support

Using the Power Pivot add-in, learn how to create hierarchies to improve the drilldown experience in PivotTables, PivotCharts, and Power View reports.

support.microsoft.com

or perhaps...