Google Answers Logo
View Question
 
Q: Excel join/concat question ( Answered,   0 Comments )
Question  
Subject: Excel join/concat question
Category: Miscellaneous
Asked by: needhelpimmediately-ga
List Price: $10.00
Posted: 31 Jul 2006 11:38 PDT
Expires: 30 Aug 2006 11:38 PDT
Question ID: 751174
In excel I have 
- Column A with unique IDs
- Column B with text data
I need a script or formula to query A where the Unique IDs match and
then to join Column B data together seperated by a semicolon
Answer  
Subject: Re: Excel join/concat question
Answered By: elmarto-ga on 31 Jul 2006 14:39 PDT
 
Hello!
In order to accomplish that, try following these steps:

1) Sort your data by ID using the sort button. The order (ascending or
descending) doesn't matter.

2) We'll put the joined text in column C. In cell C2 (or whatever row
in which you have the first piece of data) enter the formula:
=B2

3) In the next row (cell C3 in my example) enter the formula:
=IF(A3=A2, C2 & ";" & B3, B3)

4) Drag the formula in step 3 to your last row.

That's it! I've made an example file for you so the idea is clear. You
may download it from:

http://www.filefactory.com/dlf/f/b0f278/

Notice that it's important to sort your data by ID before applying the formulas.


I hope this helps! If you have any doubt regarding my answer, please
don't hesitate to request clarification before rating it. Otherwise, I
await your rating and final comments.

Best wishes!
elmarto
Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy