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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Forum statistics

Threads
1,223,239
Messages
6,170,947
Members
452,368
Latest member
jayp2104

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