SQLite 3.27

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

CREATE TABLE table1 (`key` INTEGER INTEGER PRIMARY KEY, `uuid` TEXT, `format` TEXT, `status` TEXT);
✓
INSERT INTO table1 (`key`, `uuid`, `format`, `status`) VALUES
  ('1', 'uuid1', 'dog', 'hairy'),
  ('2', 'uuid1', 'cat', 'fluffy'),
  ('3', 'uuid2', 'dog', 'shaved'),
  ('4', 'uuid3', 'deer', 'smooth');
✓
CREATE TABLE table2(key INTEGER PRIMARY KEY, uuid TEXT, dog TEXT, cat TEXT, deer TEXT);
✓
INSERT INTO table2 (uuid, dog, cat, deer)
SELECT uuid,
       MAX(CASE WHEN format = 'dog' THEN status END),
       MAX(CASE WHEN format = 'cat' THEN status END),
       MAX(CASE WHEN format = 'deer' THEN status END)
FROM table1
GROUP BY uuid;
✓
SELECT * FROM table2;


key
uuid
dog
cat
deer


1
uuid1
hairy
fluffy
null

2
uuid2
shaved
null
null

3
uuid3
null
null
smooth

key	uuid	dog	cat	deer
1	uuid1	hairy	fluffy	null
2	uuid2	shaved	null	null
3	uuid3	null	null	smooth