PIVOT TABLES

Hi,

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

Please help.

Thanks

Kathryn
Test-5.xls
KathrynTAsked:
Who is Participating?
 
nutschConnect With a Mentor Commented:
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
 
jayakum108Connect With a Mentor Commented:
(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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.