Combine 2 rows into 1

[Pypcik27]

how do i combine 2 rows into one row?

FIN 16:20
43942 6/11/2011
I need date in time in one row next to each other.

Thank you!

 

[John Davis]

how do i combine 2 rows into one row?

FIN 16:20
43942 6/11/2011
I need date in time in one row next to each other.

Thank you!

Does this help? If you don't want too concatenate into one cell, then just spit the formulas.

 

[John Davis]

Does this help? If you don't want too concatenate into one cell, then just spit the formulas.

Oops. Forgot the formulas:

=RIGHT(A2,5) & RIGHT(A3,10)

 

[Pypcik27]

I have a lot of rows and the data that I need to combine is on every other row?

 

[John Davis]

I have a lot of rows and the data that I need to combine is on every other row?

Did you test on one of the rows that requires it to be combined? What row does your data start on?