Scraping data from XML – parent vs sub entries

[OggyMan]

Hello folks,

First thing first, it's really nice to be a member in your community. Found it the other day googling some excel questions.
Kudos to everyone who chose to be of help for other people!

Okay. I'm trying to scrape data from XML files. There's an image below for your convenience.

1. I've got hunderds of entries in the "name" column.
2. Some of them are parent-entries, some of them are sub-entries.
3. The "id" column indicates which kind of entry it is: either parent-entry or sub-entry.
4. Sub-entries always follow their parent-entries (in other words they'll be always in the rows below the parent's row)
5. All of the parent-entries read 1 (in the "id" column).
6. All of the sub-entries read a (whole) number greater than 1 (in the "id" column).
   If there are more than one sub-entry the next rows, they'll read a sequential (endless) number.

I need your kind help to make my Excel (2013) do this automatically:
Copying the "name" cell of sub-entry to a new "see also" column, in the same row as its specific parent-entry.
If there are many of them (sub-entries) – the code will put them in the same cell next to each other: A, B, C ... (seperated by comma/s).

Please condider the following:

1. Since I've got a table with an unfixed number of columns, I would like it to locate the involved columns ("id" & "name") by finding their name (and not their "x" and "y" location).
2. I would prefer it was done using a formula (since I'm much more familiar with formulas rather than VBA codes), but it's up to you, especially if using formulas makes it much more complex or difficult.

That's how it looks like (a "slim" version for your convenience):



THANK YOU IN ADVANCE!
I hope I was clear enough and put it well.

 

[OggyMan]

* In the image C5 should be "fixed abode, with no fixed abode".