Hey guys,
I have a huge problem and hope to find help in this forum.
The question is as follows:
I have one column of words, let's say:
example one 'gap'
example one 'gap'
example one 'gap'
example two 'gap'
example two 'gap'
example two 'gap'
example three 'gap'
.. and so on.
On the other hand there is a column with a list of names, like that:
Name 1
Name 2
Name 3
My goal is to "search and replace" the 'gap'-words with the names to have them like this:
example one Name 1
example one Name 2
example one Name 3
example two Name 1
example two Name 2
example two Name 3
example three Name 1
... and so on.
The whole thing gets tricky, because I have different lists of sometimes more than 1.000 names. Important sidenote: The items in the not-name-column (represented with 'example one 'gap'',....) have the same number as there are names - it looks like that:
example one 'gap'
(repeated for i-1 times)
example two 'gap'
(repeated for i-1 times)
example three 'gap'
(repeated for i-1 times)
...
example n 'gap'
(repeated for i-1 times)
Name 1
Name 2
..
Name i
Because I can't do that manually, a macro would be more than nice and a great help
Could anybody help me there? Thanks a lot in advance!!
Bookmarks