I have three levels of hierarchical data in Google Spreadsheets that looks something like this:
As data is being entered in here, I want it collect in three separate sheets like this:
The solution I am looking for is a formula driven approach. I have tried VLOOKUP but can't seem to figure out how to make it work for this situation. I have googled quite a bit and all I am getting is applying filters, or removing blank cells like this one, but that does not serve my purpose.