Column "A" needs to be header rows.

[Benzman]

Greetings!

I have looked at many different posts, but I don't see a specific answer to my question/problem. I have a sheet with over 8000 lines with 4 columns and 1400 unique customer entries that needs to have a header row.

It current looks like this...

Sold To Co: ABC Company E Mail: [email protected]
Ship To Co: ABC Company Phone: (123) 456-7890
Ship To Contact: Joe Average Fax: (098) 765-4321
Ship To Address: 12345 Circle Around Blvd
City, St, Zip: My City, ST 12345

But, needs to look like this...

Sold To Co: Ship To Co: Ship To Contact: Ship To Address: City, St, Zip: E Mail: Phone: Fax:
ABC Company ABC Company Joe Average 12345 Circle Around Blvd My City, ST 12345 [email protected] (123) 456-7890 (098) 765-4321

I have tried to create a macro, but am woefully inadequate in that area. I have also tried to copy the data from one sheet to another, but some customer entries have two or three "Ship To Contact" and "Ship To Address" lines/rows. What is exact are the field identifiers with every customer.

Any help would be greatly appreciated. Thanks!

[Benzman]

Looks like the tabs didn't stick. If someone needs to see it in .xmlx format, I'd be happy to post.