Hello,

Is there a way to combine row A and B into one row? For example, I have
data in both rows, both numeric and words. Both rows are for the same
borrower. I am trying to
combine row A and B into one row that has all the data both A and B had.

I know I can cut and paste each line, but the spreadsheet is large. Any
ideas?

Thank you

I notice that your question was answered in your earlier post. You
could follow-up there if you need more guidance.

On Jul 12, 3:32 pm, nabanco wrote:
Hello,

Is there a way to combine row A and B into one row? For example, I have
data in both rows, both numeric and words. Both rows are for the same
borrower. I am trying to
combine row A and B into one row that has all the data both A and B had.

I know I can cut and paste each line, but the spreadsheet is large. Any
ideas?

Thank you

Thu, 12 Jul 2007 12:32:01 -0700 from nabanco
:
Is there a way to combine row A and B into one row? For example, I have
data in both rows, both numeric and words. Both rows are for the same
borrower. I am trying to
combine row A and B into one row that has all the data both A and B had.

In C1, put
=A1&B1
then click and drag to the rest of C.

(By the way, A and B are columns, not rows.)

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/