Random sorting in groups?

Hello,

I have a list like this:
Sweden
Italy
USA
Russia
Italy
Greece
Australia
USA
Italy

How do I sort this list randomly but still keep the "groups" together?

The result I want would look something like this:
Italy
Italy
Italy
Sweden
Greece
Australia
USA
USA
Russia

Thanks, you guys are awesome. Works like a charm.

I thought I would be able to adapt your code to my project but I can't seem to get it working correctly.

Would it be possible make the code work for this table:
before.png

...to produce a result like this?
after.png

I need to sort by column A as primary, column L as secondary (but sorting for this column needs to be randomized) and column B as third.

I'd be very grateful for any kind of help with this :-)

Oh sorry, I was refering to your code, Karedog.

I've attached the list I'm trying to sort randomly.

Hi!
Filtered by column L, sorted by column K, sorted by column A. Column B looks empty. It looks like what you wanted?

Thanks, I tried and it seems to only sort on column A and B. The part where it's supposed to randomize and sort by column L does not work I think.

You are right, it does work as intended. Thanks a million, I would never have figured that code out for myself.