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 ?