Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables - Fill In All Rows
Besides changing the order of columns (which doesn't always work), is there a
way to get a pivot table to fill-in every row with data in all columns? Thanks, Bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables - Fill In All Rows
Like the row fields?
Not and keep it a pivottable. You could convert it to values (select, edit|copy, edit|paste special|values) (or do the same thing against a copy) Then use some of the techniques at Debra Dalgleish's site to fill the empty cells: http://www.contextures.com/xlDataEntry02.html bobs wrote: Besides changing the order of columns (which doesn't always work), is there a way to get a pivot table to fill-in every row with data in all columns? Thanks, Bob -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
overlapping pivot tables | Excel Discussion (Misc queries) | |||
Ho to Delete "Ghost" Pivot Tables | Excel Discussion (Misc queries) | |||
Problems with updating category names in pivot tables | Excel Discussion (Misc queries) | |||
How can I delete rows from Pivot Tables in Excel 2000 as in 97 | Excel Discussion (Misc queries) |