Clean up this messy column

Below is a sample of one messy column. I need it as {{target}}.

First group the values by the pattern they follow, and say how many fall in each
group. Then give me one rule per group that converts it. Then list the values
that fit no rule and would need a human — do not invent a mapping for those.

Give the rules as a formula or a short script, whichever is shorter for the job.

{{values}}

What to fill in

{{values}}

Sample values — e.g. Paste 20-30 raw values, one per line

{{target}}

Target format — e.g. ISO country code