Need to combine cells where the reference is the same.
So in column A, have references which can be repeated multiple times ( number of repetition is not determinable). Need to combine the values from Column B, where the values in column A are the same.
Example has been shown below.
Original:
A B
1.1 |this is it
1.1 |there we go
1.1 |what
1.2 | what is going on
2.3 | there
4.5 |what is it
Result:
1.1 |this is it / there we go /what
1.2 | what is going on
2.3 | there
4.5 |what is it
Are you open to using a VBA function to do this?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Any thing that will get the job done..
Take a look to this
http://www.excelforum.com/excel-form...o-persons.html
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
That is too complex and VBA needs to be updated manually.. Number of rows is a lot and would be more effort to change the script to have all details in the column A.
Can you please suggest a new VBA or a method to use formula to achieve the result??
Copy the code at the link below and paste it into a general module:
http://www.excelforum.com/showthread...=1#post3096647
Then, to use it on the worksheet:
Data Range
Enter this array formula** in E2:
=concatall(IF(A$2:A$7=D2,B$2:B$7,"")," / ")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Copy down as needed.
You can easily generate the list of unique entries from column A to column D using advanced filter:
http://contextures.com/xladvfilter01.html#FilterUR
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks