Forum Discussion
danazee
Feb 04, 2024Copper Contributor
How to Compile Data More Efficiently
Hello! Need some help from an Excel wizard! I need to pull our restaurants sales data by menu item so we know what was sold on a daily basis and can reconcile this against our inventory counts. ...
JKPieterse
Feb 05, 2024Silver Contributor
Those tabs in your Excel file, how did you get the information into them?
Does your "system" have an option to export data?
Anyway, you can paste all data below each other into one tab and then create a pivot table from that tab. Drag the Menu item to the rows section and the amount to the SUM section.
Does your "system" have an option to export data?
Anyway, you can paste all data below each other into one tab and then create a pivot table from that tab. Drag the Menu item to the rows section and the amount to the SUM section.