In theory this is the ideal but in practice it very often doesn’t work like that.
I was asked to move sqns to support a newly appointed CO. I did willing but instead of being a defined role which I was assured would happen I was dumped in a cliche Sqn with no tasking & left to rot. In 12 months despite being an experienced officer nominally 2ic of the unit qualified on shooting, radio, first aid & leadership my main achievement was updating the tea list.
It was an utterly toxic & horrible time & thankfully I was able to transfer back as otherwise I would have left.