MS Excel macro to convert an indented hierarchy into a parent/child link list

I need an excel macro to convert a hierarchy represented in the XLS attached into a link list in the same XLS file. The macro should use standard XLS functions.

The hierarchy is represented in columns A-I and the target link list data to be placed in columns (J-M)

An example of the file to be converted is attached and expected data results are represented in rows 4-17 incolumns J-M

The macro needs to work with different size hierarchies and up to 8 levels on a variable length of list.