Join Cells in One Column Based on Info in 2nd Column

Hello folks,

Here's the issue I'd like to ask this forum for some help with:

Column1 has text and Column2 has a Case number.

The text is split into a new row after a certain amount of characters, even though the narrative doesn't end. The Case number is repeated for every row where the text is continued.

The question is, can I get excel to combine each cell in the first column that has the same value in the case number column?

I've attached an example of what I'm talking about, with 21 rows and 9 case numbers: Example.xls

Thank you so much! I'd really appreciate any advice!

Originally Posted by fedorzarkhin

What exactly is a macro, and how would I use one here?

A macro (or VBA) is a program that can manipulate your data. It will convert it from what you have to what you want.

If you don't know what VBA is, then you wont know what to do with the code below. Take a look at this site I created a few years ago on how you can access the VBA editor and paste the code.

http://mixednuts.net.au/matts_stuff/vba.php

Here is the VBA code that will combine the cells for you.
Note, it assumes you data is exactly like you have it in your sample sheet. Ie it starts in cell A1 and has 2 columns of data.

Please Login or Register  to view this content.

Once you paste the code into the VBA editor (see my website above), you should be able to run the code from the menu. I am not sure if the VBA menu is visible by default in a Mac version. In case you can't work it out, I have added your sample book here with the code included and a button to run the code. At least you will see how it works, and maybe then can work it out from there.