Multiple lines into one?

[Maral_]

Hello

I have a continuous event of 4315 days presented in multi-lines (22 lines). Is there an easy way to connect (not copy and paste since I have hundreds of events and thousands of lines) each line with the one comes after and to present the 4315 events in one line?

Attached is an example.
Many thanks in advanced

[TMS]

With Office 365, try:

Please Login or Register  to view this content.

[Maral_]

Thank you very much, TMS

I am not familiar with formulas, how can I use it?

Apologies for the inconvenience!

[TMS]

Type it into a cell and press Enter.

[Maral_]

Thanks, TMS but unfortunately the formula is not working!

[TMS]

See the updated example