formula to find 3 filled values in range 2

[robertsquestion]

Hi,

I'm using an Excel-2003 spreadsheet with 20 columns:
A: Productname
B: Quantity
C: Productname
D: Quantity
E: Productname
F: Quantity
etc. untill column T.

The Productname-columns contain Text and the Quantity-columns contain Numbers.
On every row, a maximum of 3 Productname columns are filled (so there could be zero, one, two or three Productnames filled on any row).
Now the question is: in columns U, V and W we would like to see the productnames that are filled on that row. So if no productnames are filled on that row, columns U, V and W should also be empty. And if there's just one productname filled, there should only be a value in column U etc.

I hope this explanation is clear. I've tried some array formula's, but that didn't work because of the mixture of text/numbers on a row and because of empty cells.

I hope someone out there can help me out!
Thanks in advance for your help.

Robert
The Netherlands

 

[robertsquestion]

Hi Rofeu,

Just fantastic, works like a charm!!
This is the solution I was looking for, thanks a lot for your help.

Regards,
Robert

 

[robertsquestion]

Hi Skip,

Thanks for your help concerning this issue. I will use the solution from Rofeu as final solution, but have also learned some new things via your answers. So thanks a lot!

Regards,
Robert