Making two lines into one

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nabanco - 12 Jul 2007 13:00 GMT

Hello,

Is there a way to combine row A and B into one row? For example, I have
data in both rows. 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

Reply to this Message

bj - 12 Jul 2007 13:08 GMT

what is he format of what you currently have, and what format do you want to
finish up with.
there are several ways to do what what you want, but different formats work
better with different methods

> Hello,
>
[quoted text clipped - 6 lines]
>
> Thank you

Reply to this Message

bj - 12 Jul 2007 13:22 GMT

among the difficulties is whether there are functions that need to refer to
specific relative cells.
if it is all data, a simple method is to go past the end of the first data
row and enter = the first cell in the second row. copy and paste this cell
across to get all the data in the second row
copy these new cells and the blank cells just below them and paste down to
the end of your data.
select all of these new columns copy and paste special values.
select one of these new columns and data filter autofilter
select blanks and delete the filtered rows.

> what is he format of what you currently have, and what format do you want to
> finish up with.
[quoted text clipped - 11 lines]
> >
> > Thank you

Reply to this Message

ryguy7272 - 12 Jul 2007 20:22 GMT

Try something like this:

=A1&A2&A3

or

=TRIM(A1)&" "&SUBSTITUTE(TRIM(B1),CHAR(10),"")

If you need to use VBA, let post back.

> Hello,
>
[quoted text clipped - 6 lines]
>
> Thank you

Reply to this Message