Order horizontal lines by skipping empty cells

**Hitch75** · 06-07-2010, 05:51 AM

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!!

**pb71** · 06-07-2010, 01:44 PM

Can you work with this? It assumes you have empty cells and not "***" in them.

**Hitch75** · 06-09-2010, 10:47 AM

Yes! It's actually perfect

Thanks a lot!!

**Hitch75** · 09-03-2010, 09:15 AM

Hello again!
This was supposed to be solved long time ago, but actually it doesn't work if some of the cells contain formulas, whose result is "".

So, in the example I attached, all the rows are ok, except for the last one.
I want it to return "word1 word2 word3 word1".

Any ideas?