Parent child relationships(working out parent item) for each item

It's not a case of knowing more one of writing.
Somebody would need to write the VBA solution. That task is way beyond the remit of a free help forum.