Consolidate mutiple rows into one row based on ID

**momozozo** · 08-14-2012, 04:08 PM

Hello all,

Please see this image to better explain what I'm trying to do: http://i48.tinypic.com/6ep6og.jpg

What's the best way to tackle this, any short macros or VBA's to do the job?

Thanks

**Andrew-R** · 08-14-2012, 05:08 PM

It's virtually impossible to use formula to concatenate an arbitrary number of strings, this would really be a job for a macro or a user-defined function.

Something like this, perhaps:

Please Login or Register  to view this content.

So if, say, your ABCD bit was in A1:A10 and the values for concatenating were in B1:B10 you could use:

=CONCATENATEIF(A1:A10,"ABCD1242",B1:B10)

Does that help?

**stanleydgromjr** · 08-14-2012, 05:14 PM

momozozo,

You are posting a picture/graphic. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense and I doubt that you would get any answer.

And, we can not tell what cells, rows, columns, your raw data is in.

To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed/changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

**JBeaucaire** · 08-14-2012, 09:19 PM

MERGE ROWS
Here's a macro for merging rows of data using the ID in column A and putting the column B values together in a delimited manner of your choosing. There's a sample file as well for testing.

Merge Rows

BTW, I have merged your two threads into one. As per forum rules, do not duplicate your topic.