You say: "The hard part (I think) is getting multiple columns that each
have a different record." What do you mean by "record"?
I imagine placing these "charts" in different sheets, one "chart" or room,
per sheet. The sheet would have the room number at the top. The "chart"
would consist of placing the names in individual columns (such columns are
called "rows" in a classroom), with maybe a blank narrow column between the
"rows" to separate them, and maybe blank rows to provide some separation
front to back, very much what you showed in your original post. Does this
sound like what you want? HTH Otto

"jschping" wrote in message
...
Hi,

I want to make a seating chart report for my student's finals testing.

I have an Excel spreadsheet with each student's name, their room number,
row
number, seat number.

I want to make a chart that is a visual aid to where they sit. So I don't
jsut want a table listing of names and rows, I want it to come out in the
rows and in the right order. It doesn't have to be spectacular, but it
should
be a visual aid.

For example:

------------------------------ROOM 201

ROW 1------------ROW 2------------- ROW 3--------------- ROW 4

Jack Frost----- Amelia Earheart--- George Washington -----Joe Shmoe

Marie Curie----- Abe Lincoln --------Hillary Clinton -------Marc Summers

(The lines are just to hold the place so you can see where everything
should
be.)

And then do the next room.

How should I do this? How should I structure my table(s)?

The hard part (I think) is getting multiple columns that each have a
different record.

Thanks!