Hello im new to macros and was wondering if I could get some help.

I have a file that is in txt format. When I load this file into excel, it lists all the rows of information under one column (attachment called sample.xls). I need a macros that will reorganize this column in a certain order. I have attached an example of the text file called sample2.txt (keep inm ind that this text file's order will change and is not always static, depending on the file, but it will always be in text format). Ive also included a sample of what the output should look like, but is in a .txt format but the arrangement is what im looking for with the proper value its associated with.


Thanks!!

**i also have to do some name conversions. For example if i have "Country Code" on the excel spreadsheet, i want to reorganize it in the order as the text file attached but also rename it to "Merchant_country_code" for example.

**Also, there are some rows on the excel file that are unecessary, how would i delete these rows in the macros?







***im nto sure if the excel file uploaded okay, but im pasting the data below:


XXXXXXXXXX

XXXXXXXX
XXXXXXXXXXXXXXX


Customer Service: 1-800-888-8888
Merchant Name BLAH BLAH BLAH
INC Terminal Number 1111
Merchant Terminal TID 1111111
DBA City CityVille
DBA State OO
DBA Zip 55555
DBA Phone 1800-888-8888
Daylight Savings No
SIC 1111
Industry E-Commerce
Country Code 111
Debit No
Currency Code 111
Merchant Agent 111
Language 00
Sharing Group
Agent Number 000011
Chain Number 0000011
MID 123456789011234
Store Number 12345
Merchant Location Number 12345