Text to Rows

Joined
Dec 16, 2014
Messages
1
Reaction score
0
Hi guys, i'm really hoping someone can help me as i'm very new to Excel.
I have a .csv file with around 200 rows and 4 columns (SKU, SIZE, TITLE, QTY)

Basically the SIZE & QTY columns are pipe delimited for example 36|38|39|40 1|3|2|1

So for size 36 there is 1 in stock, 38 there is 3 etc etc

What i would like to do is somehow create a new row for each variation copying the SKU & TITLE and separating the delimited values, putting the SIZE & relevant QTY into that row.

I would greatly appreciate any help.

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top