concatenate two rows in one

[vojinb]

Hi,
I have column in table (imported from txt file) where two rows next to each other belong to same data like:
column1
row1 LD.1.TR.EUR.21050.1009.1700.Y .YU . YU.
row2 1.T.LONG.99

How can I concatenate or append lower row to row above to have it like :
LD.1.TR.EUR.21050.1009.1700.Y .YU . YU.1.T.LONG.99
Thanks

 

[sxschech]

will the second row always have 3 dots or less data than the first row or is there some identifying data in the second row that ties it to the first or is it wrapping data from row one to row two?

 

[vojinb]

Hi, there is no rule except that second row has no more than 10 characters