printing format

From: nathan D (anonymous_at_discussions.microsoft.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 07:21:09 -0800

hello,
probably quite simple, but, i have a pivot table, very, very long, but very thin, obviously this prints out on about 10 pages as a very long table.
is there any way i can just repeat the columns and stick it on one page?

i.e its like this
 fruit no.
  apple 2
 apple 1
apple 3
apple 4
apple 2
apple 1
apple 3
apple 2
apple 4
apple 1
apple 2
apple 3
apple 4
etc.

and i'd like it to look like this

fruit no. fruit no. fruit no. fruit no.
apple 1 apple 2 apple 4 apple 3
apple 3 etc.

hope you get the message and i think this is the longest problem posed so far.

ta