2 Simple Solutions: Reverse PIVOT and UNION
Reverse PIVOT\n\n\nSELECT product_id,store,price\nFROM Products\nUNPIVOT\n(\n\tprice\n\tFOR store in (store1,store2,store3)\n) AS T\n\n\nUNION\n\n\nSELECT produ
Reverse PIVOT\n\n```\nSELECT product_id,store,price\nFROM Products\nUNPIVOT\n(\n\tprice\n\tFOR store in (store1,store2,store3)\n) AS T\n```\n\nUNION\n\n```\nSELECT product_id, \'store1\' AS store, store1 AS price FROM Products WHERE store1 IS NOT NULL\nUNION \nSELECT product_id, \'store2\' AS store, store2 AS price FROM Products WHERE store2 IS NOT NULL\nUNION \nSELECT product_id, \'store3\' AS store, store3 AS price FROM Products WHERE store3 IS NOT NULL\n\nORDER BY 1,2 ASC\n```
[]