Parent/Child flat heirarchy formula needed

jgroverm Posts 2 Registration date Friday May 5, 2017 Status Member Last seen May 5, 2017 - May 5, 2017 at 01:13 AM

I need to compare data from one column to a another column in a hierarchy level, so if the level is 1, there is information in different columns that need to be transposed to another spreadsheet in the same work book, then it needs to have all the Level 2 data transposed in columns next the information for the parent, I am hoping someone knows of a formula that might make this more of an automated task, instead of cutting and pasting.

I've attached a screenshot of what I'm talking about hope it's not confusing.