Children rows only for specific columns
I am currently trying to merge two sheets that have been created in my company. One has a list of projects/sales on it the other one has just the hardware for each project/sale. I had tried adding a new child row for each product under each project/sale to track quantities and production dates for each product. But this way I either end up having to copy the parent information into the children rows or I would end up with a whole lot of empty cells.
Is there a way to nest the products with quantities somehow ?