We have a lot of customers and various products in our portfolio but owing to poor record keeping, we do not have a proper database with differentiated sheets for everything.
Now, is there a way we can extract the information of all the customers we have had since the beginning and also the products from a single orders sheet that has all the required details through Astera Centerprise?
I have tried doing it but the customers’ and products’ occurrence repeat in respective columns and that leads to multiple counting.