Hi...I have a spreadsheet with various columns. One column is the “Category” field and another one is the “Description” field.
Where the category field says “Sales” the description field has content made up of a few elements and I want to separate the elements into other fields named Reference1, Reference2, Reference3 and Referance4.
The description field is something like this
Item - Ford Part Number - 1234 Customer Number – XXX111 Customer Name – JB
In the Reference1 field I need something like where IF the category = “Sales” I want the “Item” to appear in Reference1 else Reference1
In the Reference2 field I need something like where IF the category = “Sales” I want the “Part Number” to appear in Reference2 else Reference2
The same for Reference3 and Reference4.
Hi yes in the example the Item is "Ford", Part number is "1234", Customer number is "XXX111" and the Customer name is "JB
Each part is separated by a -
So the first parse can't be based on the "-" so is the labeling consistent, for example you'll always have "Item," "Part Number," "Customer Number" and "Customer Name?"
So the first parse can't be based on the "-" so is the labeling consistent, for example you'll always have "Item," "Part Number," "Customer Number" and "Customer Name?"
The labeling will always be the same just the descriptions will change.
The category could be 'Sales', 'Purchases' etc. so it's only for where the category is 'Sales'.