Postgres 12

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

create table count_shifts (Shift text, day01 int, day02 int, day03 int, day04 int);
insert into count_shifts
values
('D',133,123,16,124),
('N',12,3,15,4),
('X',2,4,5,6),
('F',25,32,32,64),
('C',1,3,0,1);
5 rows affected

select day, 
       (shifts ->> 'D')::int as D,
       (shifts ->> 'N')::int as n,
       (shifts ->> 'X')::int as x,
       (shifts ->> 'F')::int as f,
       (shifts ->> 'C')::int as c
from (       
  select day, jsonb_object_agg(shift, value) shifts
  from (
    select to_jsonb(s) ->> 'shift' as shift, x.*
    from count_shifts s
      cross join jsonb_each(to_jsonb(s)) as x (day, value)
    where x.day <> 'shift'
  ) t1
  group by day
) t2 
order by day;


day
d
n
x
f
c


day01
133
12
2
25
1

day02
123
3
4
32
3

day03
16
15
5
32
0

day04
124
4
6
64
1