Forum Discussion
How to merge fields to perform math functions - imported from Amazon
On Amazon we sell many of the same item under several different ASINs. Once we import our monthly sales reports into Excel, we are trying to find a way to group those ASINs that correlate to the same...
You might create a pivot table based on the data.
Add ASIN to the Rows area and #sold and profit to the Values area.
See for example Pivot Tables
- Thank you that seems to work! Is there a way that we can save the Pivot Tables and automatically run them for each month when sales reports are imported? The other issue is the number of Pivot Tables that would be needed to be run, as we have about 800 unique items and 2600+ total SKUs.
In that case you might need something else - perhaps PowerQuery. I hope that others can comment on that.
