Need to create test data from prod

[Guest]

I need to retain the actual data but but mismatch the columns to produce test
data for a development group. For example, for a table containing UserID,
Name, and SSN the values must be retained but not be in the same record.
Example:
Actual
UserID Name SSN
ABCD Doug 123-45-6789
DCBA Mary 987-65-4321
EFGH Brad 432-11-7897
Test File
ABCD Mary 432-11-7897
DCBA Brad 123-45-6789
EFGH Doug 987-65-4321

Can I do this in a query or through VBA code?

 

[Guest]

If this is a one time shot I would copy to Excel, sort name column alone
ascending and SSN sorted alone descending. This will mix them up as you
indicate.

 

[Guest]

The table is very large, 1.3 million records with 40 fields, so Excel 2003 is
not an option unfortunately - 1.2 gigs. Can Excel 2007 do it?