ritriev more than one text value to one cell

[lauberd]

Hello to all,

I have a worksheet with several repeated item but with diffrent text values.
Is thare a way to join all the items in one row and in the second row have the text values in one cell (like CONCATENATE to all text values).

This is very URGENT, Please help

Thank You,
Danny

[oldchippy]

If you have text values in A1:C1, you can join then together with

=CONCATENATE(A1," ",B1," ",C1)

or

=A1&" "&B1&" "C1

if you need to separate a string of text into separate cells, then go to Data > Text to Columns, Step 1 Delimited, Step 2 click space, Finish