Pivot table

Resolved · Low Priority · Version Standard

Thu 6 Mar 2008, 13:46 Delegate Sofia said...

Sofia has attended:
Project Intro Intermediate course

Pivot table

How do I create a pivot table from two excel sheets with data (same columns, just data that stretches over two sheets)? I have tried to use multiple consolidation ranges in step 1 but then it groups columns into "row", "column", "value", "page 1" as items. I need to have each column as a separate item.

Mon 10 Mar 2008, 00:10 Trainer Mara said...

RE: Pivot table

Hello Sofia,
I hope you enjoyed your Project training session with us.

In response to your question, I am not aware of a way of creating a pivot table that draws its data across multiple sheets, other than how you have already tried. The only other thing I can think of is perhaps you could first consolidate the data, then run the pivot table off the new consolidation? Please try this and let me know if it does the trick.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Move or Highlight Cells

Use any of your movement keys, cursor, Home, End, PgUp or PgDn to highlight cells rows or columns by holding down the Shift key as you move.

Use in combination with the Ctrl key for quicker movements.

View all Excel hints and tips