Pivot Table with lots of columns of source data

[hjgc]

My source data has lots of columns, and I need them all in the pivot table
itself. Is there a quick way of getting them into the pivot table, or do I
need to drag and drop them in one-by-one (which is rather tedious!) ??

 

[Suleman Peerzade]

Hi,

You need to select the entire table as table array for the pivot table while
you are creating one.
The table will automatically reflect all the columns select by you from the
source data. No need of drag and drop things

 

[hjgc]

Hi, thanks for that, I'm still a bit confused though, as surely I will still
need to drag and drop the pivot table fields into the "data" area?

E.g. if I have sales for 100 different weeks, and I want my final pivot
table to have 100 columns. So I highlight all the source data before making
the pivot table, however then how do I make each of the weeks be a column in
my pivot table? This is where I was having to "drag and drop" before?

Thanks! And apologies if I'm missing something obvious.

 

[Suleman Peerzade]

Hi,

I tried your way and it is true. Do this way arrange your data as below
Week Sales Name of the sales Man

Now below the "week column" you can put any number of weeks (more than 100),
in "Sales column" it will say total sales for that week and in the Names
column you can record the name of the person who has given more sales for
that week.

When you creat the pivot using this method the you will find only 3 fields
to be dropped in the pivot tabel field area.
You can drop "weeks" in the page field, drop "names" in the row field and
"sales" in the data field.

This should sort the problem.

 

[Herbert Seidenberg]

At Step 1 of the PT Wizard, choose
Multiple Consolidation Ranges.
Make sure the column you want to use as ROW
is the first column.