• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • Last Modified:

PIVOT TABLES

Hi,

I failed to create a Pivot Table from "All"  worksheet.

Please help.

Thanks

Kathryn
Test-5.xls
0
KathrynT
Asked:
KathrynT
  • 3
2 Solutions
 
nutschCommented:
unmerge cell M4:M5 and add a title in cell M5.
Add a title in cell A5 if you want that column in your pivot.
Run the pivot with range starting in row5

Thomas
0
 
KathrynTAuthor Commented:
Thanks, Thomas.

I'm going to try out.

Kathryn
0
 
jayakum108Commented:
(1) You've got Columns L and M hidden.  I unhid them.
(2) M4 and M5 were merged.  I unmerged them.  This way, you can select just row 5 as the title column.  Otherwise you will select Row 4 as title row, which has not titles.
(3) This still did not work for me.  So I copied the entire data and pasted values into a new workbook.

After that, it worked well for me.

Best,
Jay
0
 
KathrynTAuthor Commented:
Thanks.
0
 
KathrynTAuthor Commented:
I like to close today.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now