P
Pivot Table Mystery Blank Column
Hello there,
Perhaps someone can help! I am new to doing pivot tables. Basically i've
copy and pasted data onto excel, and ran a pivot table of the calculations.
The first file worked out great, but when i tried to copy and paste it into
the next file for the next months' data, it added a "(blank)" column, which
threw off my calculations by one column, i.e. E3 had to get changed to F3 to
have the right calculations. The mystery is- Where did this extra blank
column come from and how do i get rid of it?
Thanks!
Perhaps someone can help! I am new to doing pivot tables. Basically i've
copy and pasted data onto excel, and ran a pivot table of the calculations.
The first file worked out great, but when i tried to copy and paste it into
the next file for the next months' data, it added a "(blank)" column, which
threw off my calculations by one column, i.e. E3 had to get changed to F3 to
have the right calculations. The mystery is- Where did this extra blank
column come from and how do i get rid of it?
Thanks!