How to merge cells, with out loosing text

[Flabbergaster]

Hi

I have a set of data, which has a bad format for the analysis I'm going to make of it.
It's made up of cases, which is indicated in the first columns, then there's a lot of keywords in the third column, but separated in rows, the same thing goes with the last column, which is a text; i.e. description of the case.
Can I some how merge the row, that these keyword, and the text is now split into?

Here an example of how the sheet looks like

[blane245]

Since we are not sure how you are going to analyze this data, I suggest that you provide an ouptut sheet that shows how you want the data to look so that you can analyze it.

[Flabbergaster]

sorry,
I've attached another workbook, with two sheets: how it looks now, how I want it to look

[blane245]

Do you really want to merge the cells or would you prefer to concatenate the strings in columns D and E together? Also, is the merge occurring on breaks in either column a, B, or C, or do they always have the same values?

[Flabbergaster]

well, that I'm not sure.

The data is cases which has been reviewed by a juridical counsel (that's also why I've "xxx/yyy.etc'ed" it).

Column A contains the date of the specific case
Column B contains no important information
Column C contains the result of the deliberation in the counsel
Column D contains keyword applying to the case
Column E text of varying length, a sum up of the case.

I have another worksheet with the keywords generated as a case X variable matrix. So they aren't that important either.

What I need is to match the text/sum-up to the specific case in the mentioned worksheet. That is, I thought I merge the text-pieces from each case into one cell, to export it to my matrix.

Here's another workbook with three sheets; the last one is the final result I'd like to end up with. Maybe I should have made it this way from the beginning, but.... Here it is:

[Flabbergaster]

By the way, the reason I can't just do it manually is, that the data contains about 18,000 row, which is 971 cases.

[blane245]

Try running this macros and see how close we are. It will create a new worksheet called Result each time it runs, so you will need to delete it if you run it more than once.

Please Login or Register  to view this content.

[Flabbergaster]

Wow!!!! Thanks mate, that worked exactly how I imagined it!

[blane245]

Happy analyzing