Hello,
I'm hoping one of you can point me in the right direction re a tricky Excel question (at least, it seems tricky to me).
I've got a large spreadsheet of product data which I want to import into an EPOS (i.e. retail) system. One of the columns in the spreadsheet is for "Product Name", and it looks like this:
Product Name Cult small sticker pack Fiend snap back cap Black Fiend snap back cap Khaki Federal Drop bars Metallic blue 9" Federal Drop bars Metallic blue 9.25" Federal Drop bars Chrome 9" Federal Drop bars Chrome 9.25" Skull Beanie small Skull Beanie large
So, some products come in different sizes and colours, some products come in different sizes only, some products come in different colours only, and some products don't come in any such variants.
At the moment, all of that size and colour info is lumped into the "Product Name" column.
Problem is, in order to get the best out of my EPOS system, any sizes and colours need to be seperated out into different columns of the spreadsheet - i.e. they'd need to be split up a bit like this:
PRODUCT NAME COLOUR SIZE Cult small sticker pack Fiend snap back cap Black Fiend snap back cap Khaki Federal Drop bars Metallic blue 9" Federal Drop bars Metallic blue 9.25" Federal Drop bars Chrome 9" Federal Drop bars Chrome 9.25" Skull beanie Small Skull beanie Large
The spreadsheet's over 2000 lines long, so cutting and pasting all this by hand, one row at a time, would take forever.
There's got to be a way to automate this; I image there's a way Excel can be made to scan through the PRODUCT NAME column, and every time it finds a "colour" phrase, cut and paste it into column B, then do something similar with "size" phrases into column C (and presumably I'd need to write a list of what "colour" and "size" values for it to look out for)...
But, I'm damned if I know how to even start going about that.
Can anyone here help?
Thanks in advance
Bookmarks