Hey Ladies and Gents.,
This is my first thread here on the Excel Forum. So happy I found a community like this.
Here is my issue. I have attached the actual document I need sorted. Not asking you to do this for me, but as a reference and to explain how to do this for future uses. I work for a retail store that sells alcohol and tobacco. One of our vendors has asked that we give them a spreadsheet laying out the store name, transaction time, receipt number/transaction number, item description on receipt, UPC, quantity (qty), price, pack type, and extended price.
Here is my dilemma. I need this by tomorrow (Friday the 12th (luckily not the 13th or I would be really screwed!))
Here is dilemma 2...my Excel knowledge is limited although I am an IT-IS Manager for this retail business and I am ashamed to admit I could not figure this out. If you look at the attached spreadsheet. You will notice there is a transaction number column. When I use the subtotal function. It gives me a subtotal of the quantity of items for each transaction. I need it to cut the duplicates and give me a quantity on one row rather than the same item 10 times on 10 rows. Keep in mind there are more than one item on these transaction numbers and I want to account for those as well. I have also attached how I want this to look for better understanding reasons.
In advance, I appreciate your help and look forward to hearing from any of you. Thanks so much!
I have uploaded the files. The file I want you to look at is in the compressed zip folder. the finished product is the .xlsx file. Thanks again.
Bookmarks