Data Sorting Issue
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.
Re: Data Sorting Issue
Explore pivot tables - they are excellent for this sort of analysis.
Insert > Tables Group > Pivot Table
For ease of use, put it on a new sheet (default option)
You'll get a set of panes on the right-hand side. Drag Transaction no to the row labels box, Extended price to the summary box (greek sigma). You get a list of transaction with total value.
Experiment with dragging other features to other boxes and see what happens - if you don't like it, just drag them back to the top pane.
You'll be amazed what you can do with it - totals by store, average per month, all sorts!
Re: Data Sorting Issue
I should have said, before you start select any one cell in your data.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1