ajaywadhwani
New Member
- Joined
- May 17, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
- MacOS
Hello All,
I have an Excel table which has approximately 50 columns and 50K rows of the utilization of various resources in the office per day. I would like to reduce this table from a per day report to a per month report. Basically, each resource being used (for example one of the criteria is resource (example: vehicle), second criteria is 'car' third criteria would be 'name of the person using the vehicle'). Like this, I would be having 30 entries per resource. I need to create a new report (in a new Excel Worksheet (in the same Workbook)), having only 1 entry for all the 30 entries. There's also a 'Expenses' column, which needs to be summed and the sum should be in the updated report.
Below is a small snippet of the table and would need your help.
I have an Excel table which has approximately 50 columns and 50K rows of the utilization of various resources in the office per day. I would like to reduce this table from a per day report to a per month report. Basically, each resource being used (for example one of the criteria is resource (example: vehicle), second criteria is 'car' third criteria would be 'name of the person using the vehicle'). Like this, I would be having 30 entries per resource. I need to create a new report (in a new Excel Worksheet (in the same Workbook)), having only 1 entry for all the 30 entries. There's also a 'Expenses' column, which needs to be summed and the sum should be in the updated report.
Below is a small snippet of the table and would need your help.
