Parent/Child data organization

[BJLMHV]

I am trying to organize data for an upload. The upload requires columns showing "Parent ID" , "Child ID" , "Quantity" , "Parent Rev" , "Child Rev". Currently when exporting the data to be uploaded the column structure is " Level" , "ID" , "Desc" , "Quantity" , ........ , "Rev". I need a way to reorganize the downloaded data into the format for upload. I will attach pictures of both Starting format and completed format for example.


This is what the initial data download looks like.

This is what i need the final upload to look like.

The levels I am seeing can go down to 15 meaning there can be up to 15 layers of parent/child ID's.

 

[Jack George]

So there are fewer fields (header name, or columns) in the file to upload than those in the file downloaded?
And from the two pictures shown, the values in "Quantity" field equals values in field "Qty Per", if the Unit of Measurement is "EA", correct? What if "U/M" is "IN"?
Are "Parent Rev" and "Child Rev" the same? Where is the "Parent Rev" coming form?

And most importantly, the parent/child relationship is based on "Level", correct? Level 0 is the parent of level 1, and level 3 is the child of level 2, correct?

This task is trivial to accomplish, but can not be done (correctly) without those details explicitly specified. It would be best if you've written some code already and post them here.