View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johnny_99[_2_] Johnny_99[_2_] is offline
external usenet poster
 
Posts: 7
Default 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.