Pivot table with data from separate columns?

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
 
D

Dave Peterson

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.
 
Top