MySQL Solution
Let me know i\'m not alone....\n\nSelect product_id, \n\'store1\' AS store,\nstore1 AS price\nFROM Products\nWHERE store1 IS NOT NULL\n\nUNION ALL\n\nSelect pro
Let me know i\'m not alone....\n```\nSelect product_id, \n\'store1\' AS store,\nstore1 AS price\nFROM Products\nWHERE store1 IS NOT NULL\n\nUNION ALL\n\nSelect product_id, \n\'store2\' AS store,\nstore2 AS price\nFROM Products\nWHERE store2 IS NOT NULL\n\nUNION ALL\n\nSelect product_id, \n\'store3\' AS store,\nstore3 AS price\nFROM Products\nWHERE store3 IS NOT NULL;\n```
['MySQL']