This is my sample spread sheet that i create in excel.
OrderID-
Date
01/01/2025
01/01/2025
02/01/2025
02/01/2025
Product
Pen
Notebook
Mouse
Keyboard
Category Quantity Unit Price Total
Stationery
10
1.5
Stationery
5
3
Electronics
2
15
Electronics
1
25
-