Order horizontal lines by skipping empty cells

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

Yes! It's actually perfect
Thanks a lot!!

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?

Why do you have formulae in arbitrary cells?

Anyway, please see attached.