Trying to make alcohol enjoyable again

So I’m a decently new like 1-2 a week drinker and a few weeks ago I had way too much and threw up twice, and ever since then I can’t stand the sight of alcohol, it physically makes me gag, but I enjoy being drunk, is there any way to get back into it without wanting to hurl my stomach out?