So,
I'm attempting to use information from a data dump. My problem is that some of the categories have been given multiple identifiers. For example, "Oranges" are shown as having a two designations - written in the adjacent cell as North/North West.
In order for my lookups to work and the template to be fully automated I need a piece of formula that will allow me to split up those designations into two separate rows (directly on top/beneath each other) that show just "North" and "North West".
I have an if function that will be able to determine when this will need to happen and when it wont, but I can't think of a formula that I can nest inside that will actually carry out the splitting - or copying and pasting - or anything equivalent.
Is this possible?
Bookmarks