Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

We are trying to create a pivot table and combine two separate workbooks, that do not have the same data in the same cells. Is this even possible? For example the data is sales on items by month, one workbook has the sales broke down by month, the other work book has sales broke down by week. We can convert the data, before hand, but we are trying to forecast sales of times.
Solved by T. L. in 60 mins
I'm making a a pivot table with a chart. specifically a pie chart. I have multiple data to compile into one. The data I compiled is for retail stores. pertaining to inventory. within those stores I have reasons for adjusting the inventory. Then the cost that was adjusted. How do I get all the info in the pie. The pivot table looks good. Can't get the pie to reflect
Solved by A. Q. in 20 mins
I can not make a pivot table keeps saying I do not have colums
Solved by M. H. in 24 mins
Please assist I have numbers in an excel sheet but the numbers cannot be added up, the numbers appear as a 0 on my pivot table. I have tried the ALT + 0160 trick but its not working. Please assist
Solved by A. A. in 16 mins
i have a pivot table and it is showing 0 for amount values
Solved by S. H. in 45 mins
I have an existing Pivot Table of Sales Data. Item ID is a filter, but not visible in my table. I have a separate workbook with Item ID, Class A, Class B. I want to "unpivot" VLOOKUP to get Class A & Class B columns into Table Data (by Item ID), and then recreate the Pivot Table.
Solved by M. J. in 26 mins
I am trying to create a Pivot Table in Excel. I have very limited knowledge of Excel and I am having a difficult time creating one.
Solved by K. L. in 60 mins
I have a data and wanted to create pivot tables
Solved by M. D. in 22 mins
Pivot table compares codes from one worksheet to another worksheet however it will only recognize alphabetical or alpha-numberic codes (not numeric codes only).
Solved by G. W. in 27 mins
I need to consolidate a list of names based on lowest number. Each name is associated with an account and a date. For each account I need only the lowest date to show up. I am using a pivot table.
Solved by C. H. in 60 mins
1 2 3 6 7