Hello guys
Can someone help me solve this?
I am sending you an attachment.
On the left, we have a list of 5 combinations of names. Some cells are empty.
I need formulas in the table on the right (the red one), which would return what I wrote.
The names should be ordered from left to right, skipping the empty cells, and when we reach the last name, the rest of the cells should be filled up again from the beginning (like an endless tape).
So,
***-TOM-MIKE-*** becomes: TOM-MIKE-TOM-MIKE
JOHN-NICK-***-STEVE becomes: JOHN-NICK-STEVE-JOHN
RICHARD-***-***-*** becomes RICHARD-RICHARD-RICHARD-RICHARD.
Any ideas?
Thanks!!
Bookmarks