Seamless Hierarchy Change

Good day all,   This is a somewhat tricky question to articulate properly, but I will try my best. My company uses MS Excel data is that automatically generated from a server that I have no control...