how to get the records joined?

[sumesh56]

i have all the data in B. i want the content in B2 be copied and pasted with the content in B1 .like wise the content in B5 to be copied and pasted to the content in B4. the content in B3 to be copied to D as it is.the result is shown in D in the example file attached. if it is not possible to get the result as shown in D, i will be satisfied with the result as shown in F

[sumesh56]

i got the idea of =CONCATENATE(B1,"- ",B2) but this does not give a perfect solution to my problem

[Lemice]

Hello,

This might be what you are looking for. All you have to do is select C1 to C3 and then drag them down as far as you see --- and 0.

Remember to drag them down in combo of 3 together, because they are 3 different formula.

Edit: I changed the attachment, for some reason one of them was wrong ...

[sumesh56]

Hello,

This might be what you are looking for. All you have to do is select C1 to C3 and then drag them down as far as you see --- and 0.

Remember to drag them down in combo of 3 together, because they are 3 different formula.

Edit: I changed the attachment, for some reason one of them was wrong ...

thanks lemice for the help. kinldy help to solve this issue.
in the following worksheet i have 15 records.

Site "Monte Carlo MCO"
Date "1902.02.17"
Result "1-0"
White "Adolf Albin"
Black "Louis R Eisenberg"
Site "New York, NY USA"
Date "1924.03.18"
Result "0-1"
White "Alexander Alekhine"
Black "Emanuel Lasker"
Site "London"
Date "1851.06.21"
Result "1-0"
White "Adolf Anderssen"
Black "Kieseritzky"

i want that records 1,2,and 3 be joined with a dash character in between.
likewise records 4 and 5 be joined .

the macro should be based on the first word of the string in each row AND NOT on rownumber.

the words are site, date ,results, white ,black


the outcome will be like this--15 rows will come to 6 rows.

Site "Monte Carlo MCO"-- Date "1902.02.17"---Result "1-0"
White "Adolf Albin"----Black "Louis R Eisenberg"
Site "New York, NY USA"---Date "1924.03.18"---- Result "0-1"
White "Alexander Alekhine"---Black "Emanuel Lasker"
Site "London"---Date "1851.06.21"---Result "1-0"
White "Adolf Anderssen"---Black "Kieseritzky"



with the excecution of the macro 15 records will be cut short into 6 records.if the records were from A1:A15 now it will be from A1:A6.

[sumesh56]

Hello,

This might be what you are looking for. All you have to do is select C1 to C3 and then drag them down as far as you see --- and 0.

Remember to drag them down in combo of 3 together, because they are 3 different formula.

Edit: I changed the attachment, for some reason one of them was wrong ...

thanks lemice for the help. kinldy help to solve this issue.
in the following worksheet i have 15 records.

Site "Monte Carlo MCO"
Date "1902.02.17"
Result "1-0"
White "Adolf Albin"
Black "Louis R Eisenberg"
Site "New York, NY USA"
Date "1924.03.18"
Result "0-1"
White "Alexander Alekhine"
Black "Emanuel Lasker"
Site "London"
Date "1851.06.21"
Result "1-0"
White "Adolf Anderssen"
Black "Kieseritzky"

i want that records 1,2,and 3 be joined with a dash character in between.
likewise records 4 and 5 be joined .

the macro should be based on the first word of the string in each row AND NOT on rownumber.

the words are site, date ,results, white ,black


the outcome will be like this--15 rows will come to 6 rows.

Site "Monte Carlo MCO"-- Date "1902.02.17"---Result "1-0"
White "Adolf Albin"----Black "Louis R Eisenberg"
Site "New York, NY USA"---Date "1924.03.18"---- Result "0-1"
White "Alexander Alekhine"---Black "Emanuel Lasker"
Site "London"---Date "1851.06.21"---Result "1-0"
White "Adolf Anderssen"---Black "Kieseritzky"



with the excecution of the macro 15 records will be cut short into 6 records.if the records were from A1:A15 now it will be from A1:A6.