Hi all,
I have a single column of text values in column A.
In another column (let's say, column B) I want to see all of values that contained the string "_testresult_"... but I want those to appear collected together in column B.
So for example...
excel_cells_collected.PNG
I know how to find the cells that contain "_testresult_" but what I don't know how to do is have them all appear one after the other in another column (without many cell "gaps" between each found).
FYI... if to make this work some "interim columns" have to be created, that's OK.
Any help is VERY much appreciated!
(PS: I've searched around but can't find a specific example of this... happy to be pointed at another post if this has been asked)
Cheers,
Stanbridge
Bookmarks