Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying data from pivot in columns
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying data from pivot in columns
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. "Visakha" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting data from columns and displaying them as rows | Excel Discussion (Misc queries) | |||
Useform displaying all columns with data. | Excel Programming | |||
Displaying pivot cell underlying data | Excel Discussion (Misc queries) | |||
Pivot Table (displaying data as a percentage) | Excel Discussion (Misc queries) | |||
Displaying data in pivot tables | Excel Programming |