In-love with someone who likes a different sex

I'm a straight girl and I used to be in love with my gay best friend (I got over it and we're still close af). During the time I was so, I looked it up and apparently a lot of other people also experienced it but ended up marrying their love interest.

I'm curious if anyone here has similar experiences and what were your thoughts/how did you end up where you are now. (づ￣ ³￣)づ Share anything you wanna share! I love reading stuff (=・ω・=)