Hi I have a Excel file ( stock file) and like to create a CSV file from this file .
In the first column I have a value ( product) and in the 2nd column the stock quantity.
Now I want a csv file where the product is split into several lines.
So if I have a stock of product “X” 3 pieces and product “Y” 2 pieces I want 3 lines “X” and then 2 lines “Y”.
example:
X
X
X
Y
Y
i don’t kwnow where to begin can someone put me in the right direction ?
B-its is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.