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

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

Now I'm not looking for a random scramble of the source data. In the "3x3
grid" on sheet 2, I am looking for a specific setup in the grid but not in
the order of the source data.

"Max" wrote:

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

Now I'm not looking for a random scramble of the source data.

No prob. But it certainly looked that way to me in your original posting

In the "3x3 grid" on sheet 2,
I am looking for a specific setup in the grid but not in
the order of the source data.

In what kind of specified manner then?
How is Excel going to know the association between whats in Sheet1
and how you want it set up in Sheet2?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
---

Yeah it kind of does looking back at it, but I need the same exact structure
copied over and over.

I want the same configuration of the grid in sheet 2 over and over. I want
the source data from sheet 1 to be reconfigured to be B1 then to the right A1
and below that C1. I need to jumble up the source data and reproduce the
jumbled configuration multiple times.

"Max" wrote:

Now I'm not looking for a random scramble of the source data.

No prob. But it certainly looked that way to me in your original posting

In the "3x3 grid" on sheet 2,
I am looking for a specific setup in the grid but not in
the order of the source data.

In what kind of specified manner then?
How is Excel going to know the association between whats in Sheet1
and how you want it set up in Sheet2?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
---

Looks like a tough call ..
(Your original posting showing the set-up is indecipherable)

Can you upload your sample file using a free filehost,
then post a link to it here?

For example, you could use this free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here

(Desensitize your sample as appropriate)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 16,400, Files: 356, Subscribers: 53
xdemechanik
---
"Ryan" wrote in message
...
I want the same configuration of the grid in sheet 2 over and over. I want
the source data from sheet 1 to be reconfigured to be B1 then to the right
A1
and below that C1. I need to jumble up the source data and reproduce the
jumbled configuration multiple times.