Inserting multiple rows into single row

Dear all, I am having multiple text line in the column A , now I want to get each line in the cell B1 & there is a space between each line.

Please Login or Register  to view this content.

From above I want to get the all text line , in the CELL B1 like below

Please Login or Register  to view this content.

i can do it by concatenate but the cell range of column A is not fixed , some time the range as A1:A200 . for this need macro solution .

Maybe:

Please Login or Register  to view this content.

Hi JOHN H. DAVIS , Yes ! it works perfectly. i appreciate your nice job. thanks

Your welcome. Glad to help out and thanks for the feedback.