moving 'semi'--duplicates up and alongside

**abuchan** · 04-14-2010, 03:59 PM

Attached is a sample file. Column A is an identifer for a specific property. Column B represents improvements to the property. You will notice that column A can repeat, but column B is unique to the Column A. What I hope to do is if Column A repeats itself, move the improvement into a new column, in the same row as the repeating value in Column A. Sheet 2 is a hand-prepared sheet of the desired result. The result will be Column A filled with unique values and Columns B, C, ...holding what was previously in Column B for repeating values of Column A. Hopefully, the example will be a clearer picture of what I am trying to do.

I have been working on a Macro (as it works well with the other things I am doing) but I am dealing with some faulty scripting (mine!)

Thank you in advance and any advice you can offer is appreciated!

**shg** · 04-14-2010, 05:14 PM

Try this:

Please Login or Register  to view this content.

**abuchan** · 04-14-2010, 05:22 PM

Thank you. I gave it a try on the sample file and it seems to just delete the repeats in Column A without moving the data in Column B. I need to combine the data as shown in the sample results on Sheet 2. Thank you for your effort!