asked on

Excel Combining Text

Believe this is an easy question, but just cant figure it out. Simplified, by spreadsheet has two basic fields; an identifier (A, B, C etc) and a text remarks field. What I want to do is combine all of the A's remarks, all of the B's remarks etc.

Understand I could manually do this using transpose for each group, but since it is a very long list, I was hoping for an easier way. Thanks!

A      Remark1
A      Remark2            A      Remark1      Remark2      Remark3
A      Remark3      to      B      Remark4      Remark5
B      Remark4            C      Remark6      Remark7      Remark8      Remark9
B      Remark5
C      Remark6
C      Remark7
C      Remark8
C      Remark9

mvalencia2003

tried this :
?

http://office.microsoft.com/en-us/excel-help/combine-the-contents-of-multiple-cells-HA010248390.aspx

PhxDB

ASKER

Actually, that is what I plan to do once I transpose the Remarks into a single row:

A B2&":"&C2&";"&D2 to make
A Remarks1; Remarks2; Remarks3

But I cant figure out how to first get them lined up like that. Tried to use If statements, but that got way to unwieldy to go down the length of the list. Thanks

als315

Simplest way - to do it with VBA macro. Is it acceptable?

PhxDB

ASKER

Not very good at VBA, but will give it a shot. Thanks.

ASKER CERTIFIED SOLUTION

regmigrant

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

PhxDB

ASKER

That was exactly what I was looking for. Thanks regmigrant!