I'm trying to design an input table with more than 1 "primary" (so to say) row.
What I'm trying to design is complex, so I'll describe it with a real world example.
Let's say I want to create an UI that would allow a user to define the measurement of a T-Shirt for a few different countries (USA and Italy, for example). And because each country has it's own measurement system, there is more than 1 "primary" row.
Have a look at the following picture:
Now, let's say I make an UI (table with editable cells) like this:
USAItalyChestWidth
3 34 30cm 45cm
35 32cm 46cm
4 36 34cm 47cm
37 36cm 48cm
As you can see, I'm forced to leave emtpy some of the fields in the USA column because the sizes don't match any of the Italy's sizes. And something in my head screams that this is badly designed.
How would I design such a table without cluttering the UI and without making the user create a table with empty fields?