Hi All,
I have been stuck for 2 weeks now trying to work this out. Can somebody please enlighten me?
I simplified my request and changed raw data into words so it would make some sense of what I would like to achieve.
There is a column B of dynamic mashed up data.
This data needs to be split into words and each word displayed onto separate row (Result in Column C).
As a helper there is a column A to do a lookup of how the words are meant to be separated.
<tbody>
</tbody>
What I've already tried to do is to use Concatenate function to add up all data in column B. Then Index, Match & Countif functions to do a lookup and then Substitute function to split data.
However, my Index Match Countif function works too slow on a big amount of data.
I was wondering is there another way to approach it please?
Many thanks
Juste
I have been stuck for 2 weeks now trying to work this out. Can somebody please enlighten me?
I simplified my request and changed raw data into words so it would make some sense of what I would like to achieve.
There is a column B of dynamic mashed up data.
This data needs to be split into words and each word displayed onto separate row (Result in Column C).
As a helper there is a column A to do a lookup of how the words are meant to be separated.
A | B | C |
green | light greyyellowred gold | light grey |
yellow | greenblackwhite | yellow |
light grey | silver | red gold |
cooper | bronzemidnight blue | green |
red gold | black | |
silver | white | |
black | silver | |
white | bronze | |
midnight blue | midnight blue | |
antique brass | ||
bronze |
<tbody>
</tbody>
What I've already tried to do is to use Concatenate function to add up all data in column B. Then Index, Match & Countif functions to do a lookup and then Substitute function to split data.
However, my Index Match Countif function works too slow on a big amount of data.
I was wondering is there another way to approach it please?
Many thanks
Juste