DarinM
10-29-2015, 12:01 PM
Hi all,
I'll try and give you a quick backstory on this project, i think it will be an annoying one to complete but fairly easy for you guys.
I need to make an email list to send eblasts to our customers, however, the way the data gets exported from my database makes it very difficult to IMPORT into my eblast tool.
Column A - bill to
Column B - ship to
Column C - parent - unique number that could link different billto/ship-tos (same parent company, different sub-companies)
Column D - company
Column E - address (no use)
Column F - address 2 (no use)
Column G - phone (no use)
Column H - email from database 1
Column I - second email from database 1
Column J - first name
Column K - last name
Column L - role at company
Column M - email from database 2
Column N - second email from database 2
Column O - third email from database 2
Column P - fourth email from database 2
Database 2 is more up to date than database 1. database 1 emails were from when the account was first created, database 2 is regularly changed.
The exported data has X emails, 1 name on 1 row. I'd essentially like 1 name, 1 email, 1 row. So if there was 4 emails, 1 name, 1 row, it would be same name on 4 rows, 1 email per row, then highlight the original row to show me which data has been re-organized (then ill delete it later).
I have attached my excel sample with the data examples, as well as explanations of how I'd like to have the data look. I hope it was fairly clear, I tried to break it down via situation, and before/afters.
If you could help write a macro for me to re-organize the 20,000 rows I have...that would be fantastic :)
Darin
I'll try and give you a quick backstory on this project, i think it will be an annoying one to complete but fairly easy for you guys.
I need to make an email list to send eblasts to our customers, however, the way the data gets exported from my database makes it very difficult to IMPORT into my eblast tool.
Column A - bill to
Column B - ship to
Column C - parent - unique number that could link different billto/ship-tos (same parent company, different sub-companies)
Column D - company
Column E - address (no use)
Column F - address 2 (no use)
Column G - phone (no use)
Column H - email from database 1
Column I - second email from database 1
Column J - first name
Column K - last name
Column L - role at company
Column M - email from database 2
Column N - second email from database 2
Column O - third email from database 2
Column P - fourth email from database 2
Database 2 is more up to date than database 1. database 1 emails were from when the account was first created, database 2 is regularly changed.
The exported data has X emails, 1 name on 1 row. I'd essentially like 1 name, 1 email, 1 row. So if there was 4 emails, 1 name, 1 row, it would be same name on 4 rows, 1 email per row, then highlight the original row to show me which data has been re-organized (then ill delete it later).
I have attached my excel sample with the data examples, as well as explanations of how I'd like to have the data look. I hope it was fairly clear, I tried to break it down via situation, and before/afters.
If you could help write a macro for me to re-organize the 20,000 rows I have...that would be fantastic :)
Darin