Unfortunately a lot of bench science can be like that. Don't let it get to you. I've had colleagues that went had months-long projects in grad school go nowhere. Just remember that every little bit of training is helpful even if the results don't always work out.
Yeah I resorted to taking a deep breath, bitching a bit and then moving on :D
A bit of bitching seems to help many people :D Some just never move on...
The secret to success: The correct amount of bitching
True that :)