When my therapist used it I thought I knew what she meant, but I was thinking of ambiguous.
Ambivalent is holding opposing feelings about the same thing or person. My friend has traits I don't like at all and when she shows them I feel like I don't like her at all. Other times I love her to death.
Or, moving away for a new exciting job... you may feel excited and looking forward to the move because the new job is a dream job you've always wanted; but at the same time, you are very sad to be leaving friends and the place you now call home.
That's ambivalence to me.
Welcome iwbt