vendredi 22 avril 2016

sqlite creating new rows based on column conditions

I receive a database like this:

Product   Condition1   Condition2   Condition 3
Computer  1            2           
Car       1            2            3

What they want from me is to export a database in this form:

Product   Condition
Computer  1
Computer  2
Car       1
Car       2
Car       3

It's a lot of data, would not make any sense to fix stuff manually. Do you have any idea how would i get dynamic solution for this. I would highly appreciate your help.

Aucun commentaire:

Enregistrer un commentaire