Macro for Org Chart with Offsets

Hello,

I am trying to write a simple Macro which would look at a corporate organizational chart in Excel. The Macro would list the company name and the parent of that company in two columns. I have attached an example of the data and the desired output. The actual data will probably consist of a thousand rows or so.

Thank you.