Excel Macro assistance please.

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 included an example of the data and the desired output. The actual data will probably consist of a thousand rows or so and up to 20 columns. Each entity is in a different column and row.

AAA
.......BBB
.............CCC
.............DDD
...................EEE
..............FFF

The desired output would be the following:

AAA.....AAA
BBB.....AAA
CCC.....BBB
DDD.....BBB
EEE.....DDD
FFF......BBB

Thank you.