Pivot Table from data table (not data LIST)


A

absolin

What are some good ways to create pivot tables when your source data is
in a table format, not a list format?

For example, how would you create a pivot table from a calendar, which
only has days' names at the top of the table, and has numerical dates
in each cell (ie a Regular calendar :)

The standard way would be to create a list of numerical dates, then add
a column and type in "Monday" for each date that is a Monday, "Tuesday"
for each Tuesday, etc.
 
Ad

Advertisements

T

Tushar Mehta

As far as I know, the PT requires the data to be in a form compatible
with the prerequiste for a relational database model. What you
describe is not an acceptable format.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Y

ychu

So now the question is that is there an easier way to convert table to
list? And then we can feed it into a pivot table.
 
Ad

Advertisements

Hi Sam

To call up the Pivot Table & Pivot Chart Wizard in Excel 2010: ALT + D
P
Alternatively add it to the QAT: More commands > All Commands > Pivo
Table & Pivot Chart Wizard > Add.

1: Tick the Multiple consolidation ranges > Next > Create a single pag
field for me > Next > Select your data > Finish.

2: Then double click the Grand Total cell.

Kevin
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top