Moving data from a row to column based on dup

**scooby103** · 12-31-2010, 03:10 PM

Originally Posted by jeffreybrown

Never mind

Hey Jeff,

It's the file on the posting Test_Data_Macro.xlsx

It has more rows / columns to show the other data necessary to be moved. Only non duplicate data needs to be moved, and then the other rows deleted (as you already created).

**jeffreybrown** · 12-31-2010, 03:25 PM

I think creating more than four contacts could be possible, but before we move further I just need to confirm your desired outcome.

Could you adjust your sample data to contain two tabs. One with the original data (no extra columns) and then a tab with the final results in the format you desire?

**scooby103** · 12-31-2010, 03:39 PM

Originally Posted by jeffreybrown

I think creating more than four contacts could be possible, but before we move further I just need to confirm your desired outcome.

Could you adjust your sample data to contain two tabs. One with the original data (no extra columns) and then a tab with the final results in the format you desire?

Hey Jeff,

Again - thanks for your help, this is awesome.

I have attached the updated sheet with the 2 tabs. The first is the *raw* data and the 2nd would be the outcome I would like to see. Again, if it's possible to create more contact areas if a company should have more (I know one company I have has 23 contacts...) that would be awesome. If not, if we could have space for 5 that would be perfect.

**scooby103** · 12-31-2010, 03:41 PM

Woops. Just re-read your request.

I have re-attached, but on the raw file I have removed the blank contact areas.

Please see attached.

**jeffreybrown** · 12-31-2010, 05:53 PM

Okay give this a try. Please test on some test data before running macro. Best way, make a copy of the data tab and then run the macro on that sheet.

I have not tested this past the amount of data included, but in awhile I will work on getting the rest done so it is more dynamic. Have to leave right now. Let me know what you think?

**jeffreybrown** · 12-31-2010, 08:50 PM

This seems to cover it.

Added a timer to the macro and tested with 3600 rows of data and it came out ok.

Note: Remember test out on test data before the real thing.

**scooby103** · 01-06-2011, 12:29 PM

Originally Posted by jeffreybrown

This seems to cover it.

Added a timer to the macro and tested with 3600 rows of data and it came out ok.

Note: Remember test out on test data before the real thing.

Hey Jeff,

Sorry for the late response, I was off for a bit.

Looks like it's 99% of the way there. I have given you a piece of the data. There are 2 spreadsheets. First has the test data (50 lines, multiple companies / employees) and the second has the outcome. It is moving the data but it appears it is not moving it to the outcome tab, only overwriting the data tab. Also, some of it doesn't appear to be going into the right columns (Contact 3 might have a phone number).

If you had the solution to these last few things you would be saving me an amazing amount of time on a weekly basis.

Thanks for all your hard work on this till now.

Cheers,