Maybe a simple set-up to provide an idea ..

Illustrated in this sample:
http://savefile.com/files/1697634
Random scramble in a 3 x 3 grid in other sht.xls

In Sheet1,
Source data (eg: names) is assumed within say, A1:I1 (9 cells)
which is to be randomized in Sheet2's 3 x 3 grid

In Sheet2,
In A1: =RAND()
In B1: =INDEX(ROW($1:$9),RANK(A1,$A$1:$A$9))
Copy A1:B1 down to B9.

Then in say, E2:
=INDEX(Sheet1!$A$1:$I$1,OFFSET($B$1,ROWS($1:1)*3-3+COLUMNS($A:A)-1,))
Copy E2 across/fill down to G4 (populate a 3 x 3 grid). Apply a simple CF to
E2:G4 to mask zero values (Cell value is equal to 0).

E2:G4 will return a random scramble of the source data in Sheet1's A1:I1
Press F9 to regenerate.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
---
"Ryan" wrote:
I have a row by row list of contacts in worksheet one that I'm trying to
convert into a mixed up stacked table format in worksheet two. How do I
quickly copy this setup but for the list on Sheet 1 Rows 2 through 500?

Sheet1!B1 Sheet1!A1 Sheet1!C1 Sheet1!H1
Sheet1!J1
Sheet1!D1
Sheet1!I1 Sheet1!K1
Sheet1!E1 Sheet1!F1 Sheet1!G1