I have implemented a much simpler climbing system using mixamo animations for myself.
with mixamo animations moving up and down is done by the animation itself and you wont have to change Z axis. but you have to edit those animations yourself to make them ready to use with UE4. things like adding root bone to them which I do with Maya.
there is a tutorial to get started with mixamo in UE4 using Maya