Spreadsheet: 856147d1705506128-complex-data-transposition-let
Sheet: this is how I want it

customer | date_rrmmdd | hour | BC | OC | PC
b | 231101 | 01:00:00 | 0.125 | 0 | 0.125
b | 231101 | 02:00:00 | 0.113 | 0 | 0.113
b | 231101 | 03:00:00 | 0.114 | 0 | 0.114
b | 231101 | 04:00:00 | 0.125 | 0 | 0.125
b | 231101 | 05:00:00 | 0.134 | 0 | 0.134
b | 231101 | 06:00:00 | 0.17 | 0 | 0.17
b | 231101 | 07:00:00 | 0.075 | 0.005 | 0.08
b | 231101 | 08:00:00 | -0.243 | 0.26 | 0.017
b | 231101 | 09:00:00 | -0.478 | 0.479 | 0.001
b | 231101 | 10:00:00 | -2.84 | 2.84 | 0
b | 231101 | 11:00:00 | -1.737 | 1.737 | 0
b | 231101 | 12:00:00 | -0.809 | 0.814 | 0.005
b | 231101 | 13:00:00 | -0.956 | 0.957 | 0.001
b | 231101 | 14:00:00 | -0.566 | 0.573 | 0.007
b | 231101 | 15:00:00 | -0.402 | 0.412 | 0.01
b | 231101 | 16:00:00 | -0.084 | 0.109 | 0.025
b | 231101 | 17:00:00 | 0.168 | 0 | 0.168
b | 231101 | 18:00:00 | 0.124 | 0 | 0.124
b | 231101 | 19:00:00 | 0.118 | 0 | 0.118
b | 231101 | 20:00:00 | 0.122 | 0 | 0.122
b | 231101 | 21:00:00 | 0.159 | 0 | 0.159
b | 231101 | 22:00:00 | 0.149 | 0 | 0.149
b | 231101 | 23:00:00 | 0.112 | 0 | 0.112
b | 231101 | 1 day, 0:00:00 | 0.113 | 0 | 0.113
b | 231101 | 1 day, 1:00:00 | 0 | 0 | 0
b | 231102 | 01:00:00 | 0 | 0.206 | 0.206
b | 231102 | 02:00:00 | 0 | 0.123 | 0.123
b | 231102 | 03:00:00 | 0 | 0.113 | 0.113
b | 231102 | 04:00:00 | 0 | 0.205 | 0.205
b | 231102 | 05:00:00 | 0 | 0.112 | 0.112
b | 231102 | 06:00:00 | 0 | 0.113 | 0.113
b | 231102 | 07:00:00 | 0.015 | 0.166 | 0.151
b | 231102 | 08:00:00 | 0.76 | 0.006 | -0.754
b | 231102 | 09:00:00 | 2.743 | 0 | -2.743
b | 231102 | 10:00:00 | 1.78 | 0 | -1.78
b | 231102 | 11:00:00 | 1.699 | 0.001 | -1.698
b | 231102 | 12:00:00 | 0.665 | 0 | -0.665
b | 231102 | 13:00:00 | 1.24 | 0 | -1.24
b | 231102 | 14:00:00 | 1.589 | 0 | -1.589
b | 231102 | 15:00:00 | 0.631 | 0.004 | -0.627
b | 231102 | 16:00:00 | 0.068 | 0.027 | -0.041
b | 231102 | 17:00:00 | 0.001 | 0.107 | 0.106
b | 231102 | 18:00:00 | 0 | 0.111 | 0.111
b | 231102 | 19:00:00 | 0 | 0.189 | 0.189
b | 231102 | 20:00:00 | 0 | 0.123 | 0.123
b | 231102 | 21:00:00 | 0 | 0.114 | 0.114
b | 231102 | 22:00:00 | 0 | 0.112 | 0.112
b | 231102 | 23:00:00 | 0 | 0.191 | 0.191
b | 231102 | 1 day, 0:00:00 | 0 | 0.113 | 0.113
b | 231102 | 1 day, 1:00:00 | 0 | 0 | 0
next | next day
next
c | 231101 | 01:00:00 | 0.178 | 0 | 0.178
c | 231101 | 02:00:00 | 0.198 | 0 | 0.198
c | 231101 | 03:00:00 | 0.198 | 0 | 0.198
c | 231101 | 04:00:00 | 0.193 | 0 | 0.193
c | 231101 | 05:00:00 | 0.167 | 0 | 0.167
c | 231101 | 06:00:00 | 0.194 | 0 | 0.194
c | 231101 | 07:00:00 | 0.167 | 0.001 | 0.168
c | 231101 | 08:00:00 | -0.338 | 0.34 | 0.002
c | 231101 | 09:00:00 | -0.715 | 0.715 | 0
c | 231101 | 10:00:00 | -3.918 | 3.918 | 0
c | 231101 | 11:00:00 | -4.129 | 4.129 | 0
c | 231101 | 12:00:00 | -3.856 | 3.856 | 0
c | 231101 | 13:00:00 | -2.205 | 2.205 | 0
c | 231101 | 14:00:00 | -0.698 | 0.698 | 0
c | 231101 | 15:00:00 | -0.28 | 0.281 | 0.001
c | 231101 | 16:00:00 | -0.068 | 0.096 | 0.028
c | 231101 | 17:00:00 | 0.182 | 0 | 0.182
c | 231101 | 18:00:00 | 0.163 | 0 | 0.163
c | 231101 | 19:00:00 | 0.193 | 0 | 0.193
c | 231101 | 20:00:00 | 0.195 | 0 | 0.195
c | 231101 | 21:00:00 | 0.196 | 0 | 0.196
c | 231101 | 22:00:00 | 0.166 | 0 | 0.166
c | 231101 | 23:00:00 | 0.189 | 0 | 0.189
c | 231101 | 1 day, 0:00:00 | 0.194 | 0 | 0.194
c | 231101 | 1 day, 1:00:00 | 0 | 0 | 0
c | 231102 | 01:00:00 | 0.2 | 0 | 0.2
c | 231102 | 02:00:00 | 0.177 | 0 | 0.177
c | 231102 | 03:00:00 | 0.181 | 0 | 0.181
c | 231102 | 04:00:00 | 0.201 | 0 | 0.201
c | 231102 | 05:00:00 | 0.196 | 0 | 0.196
c | 231102 | 06:00:00 | 0.19 | 0 | 0.19
c | 231102 | 07:00:00 | 0.102 | 0.009 | 0.111
c | 231102 | 08:00:00 | -0.857 | 0.858 | 0.001
c | 231102 | 09:00:00 | -2.565 | 2.565 | 0
c | 231102 | 10:00:00 | -3.013 | 3.013 | 0
c | 231102 | 11:00:00 | -4.568 | 4.568 | 0
c | 231102 | 12:00:00 | -4.084 | 4.084 | 0
c | 231102 | 13:00:00 | -2.996 | 2.996 | 0
c | 231102 | 14:00:00 | -1.557 | 1.557 | 0
c | 231102 | 15:00:00 | -0.196 | 0.273 | 0.077
c | 231102 | 16:00:00 | 0.372 | 0 | 0.372
c | 231102 | 17:00:00 | 0.612 | 0 | 0.612
c | 231102 | 18:00:00 | 0.739 | 0 | 0.739
c | 231102 | 19:00:00 | 0.937 | 0 | 0.937
c | 231102 | 20:00:00 | 0.818 | 0 | 0.818
c | 231102 | 21:00:00 | 0.772 | 0 | 0.772
c | 231102 | 22:00:00 | 0.484 | 0 | 0.484
c | 231102 | 23:00:00 | 0.193 | 0 | 0.193
c | 231102 | 1 day, 0:00:00 | 0.195 | 0 | 0.195
c | 231102 | 1 day, 1:00:00 |  |  | 0
next | next day
next
d
d
d
d
d