Help Concatinating cells from a column based on duplicate rows

**Rabid Squirrel** · 10-28-2011, 01:06 PM

I have a spreadsheet with multiple columns. The first column has many duplicates. For each group of the duplicate values in first column, I want to concatenate unique values in other columns. I started on the attached file by identifying the first of each unique cells. I need help on how to fill in the concatenated values.

Blue colums are the source data, Green columns are the start of the desired output and Yellow is where I need help. I manually typed the desired output in red text for the first row as an example.

Thanks

**pike** · 10-29-2011, 11:07 PM

Hi Rabid Squirrel
Welcome to the forum

Can you modify the macro?

Please Login or Register  to view this content.

**Rabid Squirrel** · 10-31-2011, 01:51 AM

Thank you.

I copied into my spreadsheet and it worked almost perfectly creating a new worksheet. Can you help with one more part of the problem? I need to have only unique cells from Columns B-E copied over. So instead of P,P,P, D it would read P, D.

It would be fine to do this in two steps if that makes it easier.

**pike** · 10-31-2011, 03:23 AM

Hi Rabid Squirrel
No problem, almost perfectly is not close enough

Please Login or Register  to view this content.

**Rabid Squirrel** · 10-31-2011, 11:24 AM

It works perfectly when I paste the code into the Challenge worksheet but when I paste into my "real" spreadsheet, I get a "Run Time Error 1004" with the following row of code highlighted in the debugger:

With Worksheets("Step 3 Paste from 2").Range("a1", Range("a" & Rows.Count).End(xlUp)).Resize(, 5)

All I changed was the worksheet name which I did with your first solution and had no problems.

**Rabid Squirrel** · 10-31-2011, 03:39 PM

Pike,

I don't know why I had that error but I rebuilt the workbook from scratch and now don't have any errors.

THANK YOU VERY MUCH!!!!!

**pike** · 10-31-2011, 04:31 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**Rabid Squirrel** · 11-02-2011, 01:21 PM

The error above is back and I can't get rid of it.

I've attached the whole workbook and I would really appreciate it if you could take a look. I'm trying to run your code to transform the data from "Step 3" into "Step 4".

I renamed the macro to BuildRCS and I don't know why it worked one time but now it gets the error and I can't figure out why.

Thank you for your help again.

**pike** · 11-02-2011, 04:31 PM

Rabid Squirrel,
Possibly you will need to have the sheet with the data visible

**Rabid Squirrel** · 11-02-2011, 04:42 PM

That was it!

I just moved the Macro button to the source data and it worked!

You Rock!

Help Concatinating cells from a column based on duplicate rows

LinkBack

Thread Tools

Rate This Thread

Display

Help Concatinating cells from a column based on duplicate rows

Re: Help Concatinating cells from a column based on duplicate rows

Re: Help Concatinating cells from a column based on duplicate rows

Re: Help Concatinating cells from a column based on duplicate rows

Re: Help Concatinating cells from a column based on duplicate rows

Re: Help Concatinating cells from a column based on duplicate rows

Re: Help Concatinating cells from a column based on duplicate rows

Re: Help Concatinating cells from a column based on duplicate rows

Re: Help Concatinating cells from a column based on duplicate rows

Re: Help Concatinating cells from a column based on duplicate rows

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions