Forum Discussion
prosportbrand
Mar 03, 2024Copper Contributor
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...
prosportbrand
Mar 03, 2024Copper Contributor
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.
HansVogelaar
Mar 03, 2024MVP
In that case you might need something else - perhaps PowerQuery. I hope that others can comment on that.