I have data that looks like this:

A B
1 Account Notes
--------- ------
2 1000 abc
3 def
4 ghi
5 1001 jkl
6 mno
7 1000 pq
8 rs
9 ... ...

Is there any way to add in a third column that concatenates the notes rows
into one row? I know doing this: =B2 & "
" &B3& "
" &B4 in cell C2
will give me what I want, but I have about 12,000 rows to sort through and I
don't want to do this all manually. Is there a way to create intermediate
columns with dummy variables to say, if A is null, but A+1 is not null,
concatenate column B for all the rows for a particular account?

Thanks.

You may want to first fill in the "blanks" in the A column. This article
explains how:
http://www.officearticles.com/excel/...soft_excel.htm
--
~Anne Troy
www.OfficeArticles.com


"aisos12" wrote:

I have data that looks like this:

A B
1 Account Notes
--------- ------
2 1000 abc
3 def
4 ghi
5 1001 jkl
6 mno
7 1000 pq
8 rs
9 ... ...

Is there any way to add in a third column that concatenates the notes rows
into one row? I know doing this: =B2 & "
" &B3& "
" &B4 in cell C2
will give me what I want, but I have about 12,000 rows to sort through and I
don't want to do this all manually. Is there a way to create intermediate
columns with dummy variables to say, if A is null, but A+1 is not null,
concatenate column B for all the rows for a particular account?

Thanks.

In cell C2, enter the formula:

=IF(A2="",C1& " " &B2,A2 & " " & B2)

and copy down to the last row of data.

If you only want to see the final row of concatenated data, in cell D2,
enter the formula:

=IF(A3<"",C2,"")

and copy down to the last row of data. You'd need to add an entry below
the last item in column A, to mark the end of the data.


aisos12 wrote:
I have data that looks like this:

A B
1 Account Notes
--------- ------
2 1000 abc
3 def
4 ghi
5 1001 jkl
6 mno
7 1000 pq
8 rs
9 ... ...

Is there any way to add in a third column that concatenates the notes rows
into one row? I know doing this: =B2 & "
" &B3& "
" &B4 in cell C2
will give me what I want, but I have about 12,000 rows to sort through and I
don't want to do this all manually. Is there a way to create intermediate
columns with dummy variables to say, if A is null, but A+1 is not null,
concatenate column B for all the rows for a particular account?

Thanks.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html