Group DB columns to be used in pivot table

M

Metallo

Hi,

I have the following problems to prepare the DB.
I need to create a Pivot Table and my source DB is Excel.
Headings go from Column A to AT, but only columns A to N will be used to
play around with the pivot, while columns O to AT are only to input values.

How can I:

1) Transform the many columns O to AT in one field called Product so that
once placed into the Column part of the Pivot I can see all the headings from
O to AT

2) How to make all the O to AT cells active so that the user can enter
values and see the changes or analyse using the A to N fields?

Examle:
A B C D E F G H I L M N Product
O P Q R S T U V....
3 8 - - 8 - 4 4....
3 4 - 6 - - 9 -.....

Hope you can help.

Regards
Alex
 
Top