I am trying to figure out how to manipulate data as on screenshot.

Is this possible in Google Sheet or should I use other tool (some database?)

I have some Car parts (Part ID) that fit the general car model (ex. VW Golf) and specific models (ex. VW Golf IV, Golf IV Kombi, Golf IV Cabrio (1j1, 1J5, 1E) 1997-2003;).

I have data entry like in Screenshot by Part ID but I want to have view by Car Model.

Multiple Car parts fits to multiple Car Models.

What software should I use to achieve manipulation like this?

Not sure if Google Sheets would be right tool for it.

enter image description here


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.