I have a BOM (Bill Of Materials) parent/child hierarchy in column "J" that needs to update if the child's parent was not found. So as you can see in the image row "1.1" has no cell with "1" above it meaning that there's no such parent. So logically I'd need to get rid of it in the whole branch.
Maybe there's a ready solution for reorganizing (updating) the hierarchy tree if the parent was not found above in the same column i.e. "J"?