Macros to Rearrange Data??

[taimysho0]

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. I need a macros that will reorganize this column in a certain order. I have attached an example of the text file (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? Thanks!sample2.txtsample.xls

[taimysho0]

sorry i just re read my post and it sounds a little confusing, the txt file that i imported into excel is the file called "sample.xls", this is the file i need to reorganize, the output of what it should look like is the file called "sample2.txt"

[AB33]

On the attached, you have data in column A only, not output data either

[taimysho0]

hello, yes there should only be one column, the ouput is part of the rows its associated with (the last values in that row is the ouput). For the outpul file, imagine it as one column as well and not two separate columns.

[taimysho0]

for ex:

Customer Service: 1-800-888-8888

^that row in the excel doc, the output is 1-800-888-8888. thats what i mean by the output is part of the row. How i want this to be formatted is Merchant_Customer_Service: 1-800-888-8888 for example. i just want this one column organized similar to the way the txt file is organized

[taimysho0]

bump for any suggestions?