Pivot table with data from separate columns?

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.

kk_oop@yahoo.com wrote:
>
> 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

--

Dave Peterson