Hey,
What you are looking for can be done through macros. Can you tell me whether the companies follow a hierarchy (parent/child relationship) or are at the same level as well. So basically, do we show vertical or horizontal or both types of relationships.
Can you share some sample data so that I may suggest the best approach to do so?
I am an expert in Excel as you would see in my work history here on freelancer and have completed more than 475 projects with consistently 'Excellent' ratings from clients across the globe.
Please drop a message to me if you would like me to work on this project for you and we may discuss the next steps.
Look forward to working with you and thank you for considering my bid.
Regards,
Rishi
Automyze Consulting - The Business Process Automation and Optimization Experts