create Pivot Table from data table (Not a list)

  • Thread starter Thread starter absolin
  • Start date Start date
A

absolin

How would I create a pivot table from a data table instead of lists?
For example, a data table where x=Monday-Friday and y=Sale
 
You could copy and paste special using Transpose to make it a list.
 
You must log in or register to reply here.

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

Similar Threads

Pivot Table Help! 1
Turning Data into a Table 1
Export Pivot table 1
Pivot table report invalid 0
making an excel table visible for external data on pivot table 1
Possible to use pivot table on non-mumeric fact data withoutcalculating? 3
pivot table loosing decimals (vba) 1
How to base a pivot table on another pivot table? 3

Back
Top