MySQL 8.0

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

CREATE TABLE mytable
(
  id int primary key auto_increment,
  col1 varchar(30),
  col2 varchar(30),
  col3 varchar(30),
  col4 varchar(30),
  col5 varchar(30)
);
INSERT INTO mytable (col1, col2, col3, col4, col5)
SELECT 'val1' as val1, null as val2, null as val3, 'val4' as val4, null as val5
UNION ALL SELECT null, 'val2', null, null, null
UNION ALL SELECT 'val1', null, 'val3', null, 'val5';
INSERT INTO mytable (col1, col2, col3, col4, col5) VALUES 
(null, 'val2', 'val3', 'val4', null),
('val1', null, 'val3', null, 'val5');
select * from mytable;


id
col1
col2
col3
col4
col5


1
val1
null
null
val4
null

2
null
val2
null
null
null

3
val1
null
val3
null
val5

4
null
val2
val3
val4
null

5
val1
null
val3
null
val5

id	col1	col2	col3	col4	col5
1	val1	null	null	val4	null
2	null	val2	null	null	null
3	val1	null	val3	null	val5
4	null	val2	val3	val4	null
5	val1	null	val3	null	val5