| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Easy way to add multiple Columns into Data section?
As with a previous question, I have a large set of data (20,000 rows and
about 100 coulmns). I wish to select about 60 columns to place in pivot "data" (along with others into "Rows"). Is there a way to select multiple columns (say all 60?) and move into "Data" in one step? Are there add-ins that help with this? Doing all 60 is possible but slow and somewhat error prone. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Showing data unigue to multiple columns in a pivot table | Excel Worksheet Functions | |||
| Multiple Field Selection for Pivot table Values Section | Excel Worksheet Functions | |||
| Using a data field twice in the 'Rows' section of a pivot table. | Excel Discussion (Misc queries) | |||
| How to have multiple columns in pivot table data area? | Excel Worksheet Functions | |||
| How to have multiple columns in pivot table data area? | Excel Worksheet Functions | |||
![Johnny_99[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
