Converting text records with 12-16 attributes each into rows in a table?

sbreth

New Member
Joined
Oct 10, 2017
Messages
1
Hi experts,
Wondering how to convert ~2000 txt records into rows in a table for refining, then doing email merge and import into email programs etc. For each record, 12-16 out of 16 attributes would be available. I have two columns of text, where Column B holds the actual values for each record, e.g. like this:
[COLUMN A] [Column B]
FULL_NAME Bill Bronco
SUFFIX CPA
CATEGORY #Prospect
EMAIL bill@bronco.com
BUSINESS_PHONE 61 3 9876 5432
JOB_TITLE COO
DEPARTMENT Operations
COMPANY Acme Ltd
BUSINESS_STREET Level 2, 18 Lindfield Terrace
BUSINESS_CITY Lindfield
BUSINESS_STATE NSW
BUSINESS_POSTCODE 2909

FULL_NAME Hannah Harvest
SUFFIX ORD
CATEGORY #Customer
EMAIL h.harvest@live.com
BUSINESS_PHONE 61 3 5432 1234
MOBILEPHONE 61444555666
JOB_TITLE Recipe developer
DEPARTMENT Production
COMPANY Country Origin Ltd
DIRECT_MANAGER Harry Handy
BUSINESS_STREET 8 Sandy Road
BUSINESS_CITY Harboard
BUSINESS_STATE NSW
BUSINESS_POSTCODE 2130

FULL_NAME Karl Kraftsman
SUFFIX COOP
CATEGORY #Competitor
EMAIL kk@outlook.com
BUSINESS_PHONE 61 7 6789 5432
JOB_TITLE Heavy Lifter
DEPARTMENT Moving
COMPANY We Load Pty Ltd
DIRECT_MANAGER Rebbecca Responsible
BUSINESS_STREET 1 Beachcombers Way
BUSINESS_CITY Bondi
BUSINESS_STATE NSW
BUSINESS_POSTCODE 2200

Any recommendation on how to do this practically, maybe with VBA?
Thanks,
Soren
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Forum statistics

Threads
1,223,996
Messages
6,175,858
Members
452,676
Latest member
woodyp

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top