Hey guys,
I know this question is likely answered somewhere here, or at least addressed... I've tried searching for any words I can think of that might relate to the question but no luck. Regardless, please see below:
Column1 Column2
Business Name Company X
Address Address XXX; city; province
Phone 1 XXX-XXX-XXXX
Fax XXX-XXX-XXXX
Email email@company.com
Website www.website.com
Business Name Company Y
Address Address XXX; city; province
Phone 1 XXX-XXX-XXXX
Fax XXX-XXX-XXXX
Email email@company.com
Website www.website.com
See file here:
http://www.rawkmedia.com/Customer-Sample.xls
My question is, is there an easy way or macro out there to convert the above records (1000's), that were kept in such a stupid format for years, into the proper format (each column representing Business Name, Address, Phone, etc) for importing into a database?
Does my question make sense?
Anyway, any help would be HUGE!
Thanks!!
J.
I know this question is likely answered somewhere here, or at least addressed... I've tried searching for any words I can think of that might relate to the question but no luck. Regardless, please see below:
Column1 Column2
Business Name Company X
Address Address XXX; city; province
Phone 1 XXX-XXX-XXXX
Fax XXX-XXX-XXXX
Email email@company.com
Website www.website.com
Business Name Company Y
Address Address XXX; city; province
Phone 1 XXX-XXX-XXXX
Fax XXX-XXX-XXXX
Email email@company.com
Website www.website.com
See file here:
http://www.rawkmedia.com/Customer-Sample.xls
My question is, is there an easy way or macro out there to convert the above records (1000's), that were kept in such a stupid format for years, into the proper format (each column representing Business Name, Address, Phone, etc) for importing into a database?
Does my question make sense?
Anyway, any help would be HUGE!
Thanks!!
J.
Last edited: