[libreoffice-users] Can I Do This in Calc?

I have a list of names in col A.

What I want to do is find a quick and dirty way to create a random list
of pairs (different each time I do it).

Example

Jack
Joe
Sally
Sue
Paul
John
Ringo
Earl

The desired result would be written to col B (or perhaps to B and C if
that's easier) and would be something like

Earl, Sally
Paul, Ringo
Sue, Jack
John, Joe

The next time I do it, the result might be

Sally, Sue
Paul, Joe
John, Ringo
Earl, Jack.

Thanks.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted