Your main problem is that your table is designed like a spreadsheet. There may be a fix for your issue using what you have but you will continue to have more issues. Review database normalization. You really should have a table for radios, one for tubes and one that's known as a junction table. Imagine you get another radio and it has a tube that's not in your table. Now you have to redesign all your queries, forms, reports, etc. to accommodate this. That is the surest sign of design issues.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.