Look at the 2 different tabs on the bottom of the spreadsheet, one called "AS IS" and the other "TO BE".
Now, I am getting reports of items (SKU's) in the "AS IS" format.
Can I manipulate it so it will be like in "TO BE" sheet?
I need this to be more than a one-off. I mean: I get those new reports all the time. What I want is the method so I could make a "AS IS" to a "TO BE" on a regular basis.
Solved by Z. C. in 11 mins