Sorry, but you really need the very thing that you say that you don't want: A table with one record for every product with fields for model number and price. Import Records with a unique value validation makes this a pretty easy thing to create.
Yah. Seems like it.
It really makes sense.
I built a simplified layout, exported it to excel, removed duplicates, built a new table, and dumped in the model numbers. I'm then handing that down to purchasing/engineering to fill in the values as they see fit.
Thanks for the help.
But there was a simpler way:
Create a new FileMaker Table with the Model Number and Price fields. May want other fields such as a name or description, but you need those two.
On the Model number field set up to validation options: Unique Values, Validate Always.
Then Use Import Records to import all the records from the current table into this new table. The duplicates are automatically removed during import and both target and source table can be in the same file even though it may not look like it.