Thank you for your comments. I'm finding them really hard to separate. I would definitely spell Margot with a 't' but do worry people would mispronounce it.
I'd love to hear from any older Margots or people who know a Margot to know how they feel about their name. Thanks again.