BOM: Multi-part component assemblies best practices?

May be try this solution schematic to spreed sheet and vice versa