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