MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mytable (
Seasonid INT,
Product VARCHAR(255),
Facility VARCHAR(255),	
Price INT,
ProductType VARCHAR(255));

INSERT INTO mytable VALUES
(1,'Socks','Montreal',24,'Wool'),
(2,'Slippers','Mexico',50,'Poly'),
(3,'Slippers','Montreal',27,'Rubber'),
(4,'Socks','Mexico',24,'Cotton'),
(5,'Socks','Montreal',26,'Cotton');
SELECT * FROM mytable;


Seasonid
Product
Facility
Price
ProductType


1
Socks
Montreal
24
Wool

2
Slippers
Mexico
50
Poly

3
Slippers
Montreal
27
Rubber

4
Socks
Mexico
24
Cotton

5
Socks
Montreal
26
Cotton


SELECT seasonid,
       Product,
       CASE WHEN Facility='Montreal' THEN Price ELSE 0 END AS 'Montreal',
       CASE WHEN Facility='Mexico' THEN Price ELSE 0 END AS 'Mexico',
       ProductType
FROM mytable;


seasonid
Product
Montreal
Mexico
ProductType


1
Socks
24
0
Wool

2
Slippers
0
50
Poly

3
Slippers
27
0
Rubber

4
Socks
0
24
Cotton

5
Socks
26
0
Cotton


SELECT seasonid,
       Product,
       IF(Facility='Montreal',Price,0) AS 'Montreal',
       IF(Facility='Mexico',Price,0) AS 'Mexico',
       ProductType
FROM mytable;


seasonid
Product
Montreal
Mexico
ProductType


1
Socks
24
0
Wool

2
Slippers
0
50
Poly

3
Slippers
27
0
Rubber

4
Socks
0
24
Cotton

5
Socks
26
0
Cotton

Seasonid	Product	Facility	Price	ProductType
1	Socks	Montreal	24	Wool
2	Slippers	Mexico	50	Poly
3	Slippers	Montreal	27	Rubber
4	Socks	Mexico	24	Cotton
5	Socks	Montreal	26	Cotton