Calculate one 32bit word out of 2 16bit values

I read 2 uint16 values via modbus_exporter and get them into prometheus correctly.
Now I need to combine these two values (lower and higher word …) and calculate the value of the whole 32bit-register (sorry if I mix up terms here …).

I assume I can do that inside grafana via a transformation operation? How can I do that?
help appreciated … thanks in advance.

you can add them using add field from calculation transformation, if they are strings and you add them it will concatenate them:

Thanks for the example. I currently have a “Stat” panel for that, I assume that’s wrong.
Is that a “Table” you are showing here?

works for a stat panel too:

I think I had that already. And to me it seems it doesn’t shift the higher part of the word correctly.
It simply adds the two strings, while I look for something like java - Two 16 bit ints to One 32 bit float value - Stack Overflow

it also looks different here: