Displaying data from pivot in columns

  • Thread starter Thread starter Visakha
  • Start date Start date
V

Visakha

I have a long pivot table with more than 50 records. Is there a way to
display or at least print the data by separating into 2 newspaper-like
columns (25 records for each column). The only options I can think of is
transferring to Word. Tahnks in advance!
 
not with the pivot diectly. cutting/pasting is a simplistic way. turn on the
macro recorder to repeat what you do.

In the past I've added a new field,"Page#" which repeats 1 25x then
incremenst to 2 for a count of 25
if my field is in column D, with D1 as tthe header, then D2 has the value 1
and D3 has the formula
=IF(COUNTIF($D$2:D2,D2)>=25,D2+1,D2)
repeat the formula down the column

you can now use the Page number as the page field

Hope this gives you some ideas.
 
Back
Top