Oracle 23c

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

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS (DY)';
ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF';
CREATE TABLE table_name (customer, value1, value2, value3, value4, value5, value6, value7, value8) AS
SELECT 100, 1, 2, 5, 3, 2, 1, 2, 1 FROM DUAL UNION ALL
SELECT 100, 1, 3, 4, 3, 2, 5, 2, 1 FROM DUAL UNION ALL
SELECT 101, 3, 2, 2, 2, 2, 1, 2, 1 FROM DUAL UNION ALL
SELECT 101, 3, 2, 1, 2, 1, 3, 5, 2 FROM DUAL UNION ALL
SELECT 101, 2, 2, 5, 4, 2, 3, 4, 3 FROM DUAL;
5 rows affected

SELECT *
FROM   table_name
UNPIVOT (
  value
  FOR columns IN (value1, value2, value3, value4, value5, value6, value7, value8)
)
PIVOT (
  COUNT(*)
  FOR value IN (1, 2, 3, 4, 5)
)


CUSTOMER
COLUMNS
1
2
3
4
5


100
VALUE1
2
0
0
0
0

100
VALUE2
0
1
1
0
0

100
VALUE3
0
0
0
1
1

100
VALUE4
0
0
2
0
0

100
VALUE5
0
2
0
0
0

100
VALUE6
1
0
0
0
1

100
VALUE7
0
2
0
0
0

100
VALUE8
2
0
0
0
0

101
VALUE1
0
1
2
0
0

101
VALUE2
0
3
0
0
0

101
VALUE3
1
1
0
0
1

101
VALUE4
0
2
0
1
0

101
VALUE5
1
2
0
0
0

101
VALUE6
1
0
2
0
0

101
VALUE7
0
1
0
1
1

101
VALUE8
1
1
1
0
0

CUSTOMER	COLUMNS	1	2	3	4	5
100	VALUE1	2	0	0	0	0
100	VALUE2	0	1	1	0	0
100	VALUE3	0	0	0	1	1
100	VALUE4	0	0	2	0	0
100	VALUE5	0	2	0	0	0
100	VALUE6	1	0	0	0	1
100	VALUE7	0	2	0	0	0
100	VALUE8	2	0	0	0	0
101	VALUE1	0	1	2	0	0
101	VALUE2	0	3	0	0	0
101	VALUE3	1	1	0	0	1
101	VALUE4	0	2	0	1	0
101	VALUE5	1	2	0	0	0
101	VALUE6	1	0	2	0	0
101	VALUE7	0	1	0	1	1
101	VALUE8	1	1	1	0	0