Forum Discussion
PeterBowen
Jun 26, 2023Copper Contributor
Product Count and Number Sold
I have a series of Excel worksheets in a single workbook that I create every month to track sales of products so I have columns for ITEM purchased and QUANTITY which is always one. There are up to 90...
mathetes
Jun 27, 2023Silver Contributor
How do I create a data table from my existing workbook which has 3 years of data in separate worksheets?
Probably most effectively done (unless there's a Power Query way to do it, which isn't a method I know)...by a series of copy/paste operations. This is assuming that the data in each sheet are arrayed in the same way. You'll need to add a column representing dates (months and years if that's the level of granularity you employ), but other than that just make sure you're putting each row from each month's sheet into the appropriate columns. Three years would have 36 months; so copying and pasting, adding dates, will take a bit of time, but not a lot, especially in view of the time it'll save once done.
PeterBowen
Jun 27, 2023Copper Contributor
Thank you very kindly
Peter Bowen
Peter Bowen
- mathetesJun 27, 2023Silver ContributorYou're welcome.
Once done, if you have questions on how to create summary reports, please come back and continue this thread (or start a new one). Assuming the data aren't confidential, if you could post a copy of the new consolidated spreadsheet on OneDrive or GoogleDrive, with a link here that grants access, that would help us help you.