Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

How to Compile Data More Efficiently

Copper Contributor

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.  I can pull the report in our system. However, what I am doing now is putting each day on it's own sheet since the data isn't going to be the same each day. For instance, we may sell crab legs one day but not another.  For ease of analysis, it would be great if I could get it all on one sheet.  But I can't figure out how to do it without entering the data manually, one menu item at a time. Is there an easier, more efficient way to do this?   I'm attaching a file so you have an example.

I'd appreciate any help I can get with this!  

TIA!!

1 Reply
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.