I've rotated the cylinder by 90 degrees and then performed the merge again,
I think these are the results I was expecting originally, instead of that weird outcome on the first try :)

Bryan: 180 degrees works as well, thank you.