Quote (Soroush @ Apr 8 2023 12:25pm)
Okay I understand the data much better now, but I am still wondering what it is you need to achieve.
Do you need to export every single column, but the problem is specifically with the AV column which holds multiple values, rather than just one like the rest of the sheet. So you want to export every column, and then treat AV how?
To be transparent, I'm not gifted in excel or anything, but I'm pretty sure it would be fairly straightforward to use a python script to do the export for you.. so the way I am thinking of this is less in excel terms and more in object oriented programming
This is wonderful and I want to thank you for taking the time.
I only need the information from the AV column sorted and organized.
Here is an example of the data converted to paper via written hand. You may notice the error I made just in creating the example.
This is the first 3 lines of data from the AV Column. Which is as follows;
Product Details
Product ID: 78, Product Qty: 1, Product SKU: G36, Product Name: redact, Product Weight: 5.0000, Product Variation Details: Color: Carbon Fiber, Make & Model: redact, Handing: Right Hand, Product Unit Price: 39.96, Product Total Price: 39.96
Product ID: 78, Product Qty: 1, Product SKU: G43X, Product Name:redact, Product Weight: 5.0000, Product Variation Details: Color: Tactical Black, Make & Model: redact, Handing: Right Hand, Product Unit Price: 39.96, Product Total Price: 39.96
Product ID: 78, Product Qty: 1, Product SKU: 3.8, Product Name: redact, Product Weight: 5.0000, Product Variation Details: Color: OD Green, Make & Model: redact, Handing: Right Hand, Product Unit Price: 39.96, Product Total Price: 39.96