Merge- top to bottom not left to right

[NoCLUE]

I ahve a list of over 300 names that i am tryiing merge onto a ticket
format that carries 8 tickets to a page. Problem is when I try and
merge I get all the same name on the 8 tickets each page 300 times. I
want to have each name only once --or 8 names per page. If I merge and
change the format by taking and changing each of the 8 tickets ( name1,
name2, name3 etc.) That turns into me ahveing to change up all my names
by moving them from top to bottom and going left toright.
If I could just merge them eight at a time in each column that would be
great.

 

[RagDyer]

Since you say your list contains over 300 names, I'll assume that it's in a
single column, on a sheet other then the sheets you're attempting to create
your pages of tickets.
BUT, you subject line mentions "Merge", and "*not* left to right".

If your list is in Column A, on Sheet1, this will 'link' the original list
to a column on another sheet:

=INDEX(Sheet1!A:A,ROWS($1:1))

Copying down will duplicate your list.

Post back with the configuration of your ticket "pages" (sheets?),
describing exactly what you're trying to accomplish.

 

[NoCLUE]

Yeah I was trying to keep it simple but explaining it is a little
problematic.
FIRST LAST
Ok lets say I have in col A1 A2
John Smith
Bob Jones
etc.......
If I merge onto the tickets (8 to a page) Then it does the John Smith
thing 8 times
I want the merge sequance to then go to the next name on the page Bob
Jones for ticket number two.

I suppose I need to some way change the row and name them as opposed to
the columns but am unsure how.

I just need to do one of the names per ticket and since I can get 8 to
a page it would be nice not to have to print 300 pages just to get one
ticket. I can just print out 38 pages and then have them cut into
eights.

 

[kfogle]

It is best if you begin your document as though you were Mail Merging
Labels. Create a custom label size to match your ticket size using the
"Label options..." link in your task pane.

This Mail Merge option automatically accounts for your needing to print
multiple records on the same page. You should be able to copy/paste
any special formatting from your original ticket document without a
problem.

You will see {{Next Record}} automatically populate each record once
you've located your data source. Then insert the appropriate fields
into the first label/ticket, and click the [Update All Labels] button
located in your Task Pane. This will automatically take whatever
fields you placed on the first ticket and copy them into the rest of
the tickets.

Let me know if any of this doesn't make sense!

 

[RagDyer]

Are you saying that your names are in Column A, in this configuration:
A
1 John
2 Smith
3 Bob
4 Jones
5 Al
6 Brown
7 etc. ...

And you want to copy these to your "tickets" sheet in this form:

A B
1 John Smith
2 Bob Jones
3 Al Brown
4 etc. ... etc. ...

If I guessed right, try this in A1 of your 'tickets' sheet:

=INDEX(Sheet1!$A:$A,2*ROWS($1:1)-2+COLUMNS($A:A))

And copy across to B1,
Then select *both* A1 and B1, and copy down as needed

 

[NoCLUE]

No actually they are

A B
1 John Smith
2 Bob Jones
etc.

I want to merge them onto a one page doc with eight tickets on it.When
I do this now it prints the John Smith 8 times. I want it to shift to
the next one on the next ticket ..on the same page.

The only way I know of is to make the columns into rows as the system
picks up each column for a whole page at a time...Thus giving me 300
pages of tickets with the same name 8 times..

I want to on have like 38 pages with 8 different names on each page.

 

[Ragdyer]

The formula I suggested will do just what you are asking.

Have you tried it?

 

[kfogle]

My apologies, I thought you were creating your tickets in Microsoft
Word, merging your data in from Excel. Sorry if that was confusing. :-(

 

[NoCLUE]

Actually on both of your responses are good ideas. I have not yet. run
either. Wife had a little surgery yesterday. Will do it and report back
today. Thanks


did this last year and fully developed a working program with excel for
a Mardi Gras ticket sales with a WHOLE lot of conditional formats.
worked great. and this coming form someone who never used excel.

All your help here is amazing and thanks to you all