PhilLazalde
New Member
- Joined
- Jul 9, 2010
- Messages
- 7
Hi!
I need help again with a macro to take my data that comes to me in a single column that I can transpose into single rows over multiple columns. Briefly, heres my issue; I have data that im gathering on my companies website that I cut and paste into excel and comes in the following format:
Bill's Wild Graphic
Using Millions of colors
213-621-7775
Los Angeles, Ca
bill.wild@gmail.com
www.billswildgraficcolor.com
The ColorRocker Event
Printers Are We
884-335-0439
Brea Hills, CA
Albert Einstien
Rancho Cucamonga, Ca
aleinstien2@verizon.net
Elvis is Alive
Print Contractors LIC#0003371
(310)407-2649
Riverside, Ca
elvis.alive@yahoo.com
The problem I have is the data is not uniformed, some contain 3, 4, 5 or 6 rows. I need them in a mailist format as I've detailed below (/=each in separate columns) :
Bills wild graphic / Using Millions of colors / 213-621-7775 / Los Angeles, Ca / bill.wild@gmail.com / www.billswildgraficcolor.com
The ColorRocker Event / Printers We Are / 884-335-0439 / Brea Hills, Ca
Albert Enstien / Rancho Cucamonga, Ca / aleinstien2@verizon.net
Elvis is Alive / Print Contractors LIC#0003371 / (310)407-2649 / Riverside, Ca / elvis.alive@yahoo.com[/email]
Can you help? I really need help, as my job depends on me being able to do this. I appreciate anything you can do for me. Please let me know if you need any additional information. Thanks in advance for your help!
I need help again with a macro to take my data that comes to me in a single column that I can transpose into single rows over multiple columns. Briefly, heres my issue; I have data that im gathering on my companies website that I cut and paste into excel and comes in the following format:
Bill's Wild Graphic
Using Millions of colors
213-621-7775
Los Angeles, Ca
bill.wild@gmail.com
www.billswildgraficcolor.com
The ColorRocker Event
Printers Are We
884-335-0439
Brea Hills, CA
Albert Einstien
Rancho Cucamonga, Ca
aleinstien2@verizon.net
Elvis is Alive
Print Contractors LIC#0003371
(310)407-2649
Riverside, Ca
elvis.alive@yahoo.com
The problem I have is the data is not uniformed, some contain 3, 4, 5 or 6 rows. I need them in a mailist format as I've detailed below (/=each in separate columns) :
Bills wild graphic / Using Millions of colors / 213-621-7775 / Los Angeles, Ca / bill.wild@gmail.com / www.billswildgraficcolor.com
The ColorRocker Event / Printers We Are / 884-335-0439 / Brea Hills, Ca
Albert Enstien / Rancho Cucamonga, Ca / aleinstien2@verizon.net
Elvis is Alive / Print Contractors LIC#0003371 / (310)407-2649 / Riverside, Ca / elvis.alive@yahoo.com[/email]
Can you help? I really need help, as my job depends on me being able to do this. I appreciate anything you can do for me. Please let me know if you need any additional information. Thanks in advance for your help!
Last edited: