Pivot table with data from separate columns?

  • Thread starter Thread starter kk_oop
  • Start date Start date
K

kk_oop

Hi. I want to make a pivot table using two columns from the same
table/worksheet. However, the two columns are not not next to each
other. How do I tell the Pivot Wizard to use data from these separate
columns?

Thanks!

Ken
 
Select the whole range (all the columns in that range) and just use the columns
you need. You will have to make sure that each header is non-blank, though.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Help! 1
Pivot table report invalid 0
Turning Data into a Table 1
Export Pivot table 1
making an excel table visible for external data on pivot table 1
create pivot table from multiple sheet (excell 2003) 9
Access #Error & Excel Pivot 0
remove Absolute references when copying from pivot table 4

Back
Top