sarcastress
New Member
- Joined
- Jul 9, 2008
- Messages
- 13
I swear I have done this before, but I can't remember what I did. I'm sure I would have done it with a formula or ASAP Utilities and not a macro. Maybe someone can jog my memory! I have the following type of data in columns A & B:
<TBODY>
</TBODY>
I would like to end up with this:
<TBODY>
</TBODY>
So wherever the value in column A repeats, I would like to concatenate the numbers in column B until I hit a new value in column A. If it can only be done with a macro, could someone help a girl out with some VBS? I swear I've done it with a formula in column C and I'm just making it harder than it is, but I'm stumped! Totally need more sleep.
Thanks for any answers you can give.
10017</SPAN> | 86703</SPAN> |
10017</SPAN> | 86762</SPAN> |
10017</SPAN> | 86850</SPAN> |
10017</SPAN> | 86900</SPAN> |
10017</SPAN> | 86901</SPAN> |
10017</SPAN> | 87340</SPAN> |
10020</SPAN> | 80053</SPAN> |
10020</SPAN> | 80061</SPAN> |
10020</SPAN> | 85025</SPAN> |
10050</SPAN> | 80053</SPAN> |
10050</SPAN> | 82306</SPAN> |
10050</SPAN> | 84305</SPAN> |
10050</SPAN> | 84443</SPAN> |
10050</SPAN> | 85025</SPAN> |
10050</SPAN> | 85652</SPAN> |
10050</SPAN> | 86803</SPAN> |
<TBODY>
</TBODY>
I would like to end up with this:
10017</SPAN> | 86703 86762 86850 86900 86901 87340</SPAN> |
10020</SPAN> | 80053 80061 85025</SPAN> |
10050</SPAN> | 80053 82306 84305 84443 85025 85652 86803</SPAN> |
<TBODY>
</TBODY>
So wherever the value in column A repeats, I would like to concatenate the numbers in column B until I hit a new value in column A. If it can only be done with a macro, could someone help a girl out with some VBS? I swear I've done it with a formula in column C and I'm just making it harder than it is, but I'm stumped! Totally need more sleep.
Thanks for any answers you can give.