I need to merge columns, regardless of how many rows there are. I got some
great help last week, now I need to take it a step further...

A B C D E F G
H I
Name Company Prefix Last First Suffix stuff1 stuff2
stuff3

into...

A B C D
CompanyLast, Name Suffix stuff1 Stuff2 stuff3

(I do realize I am deleting the Prefix in C)

Any help would be deeply appreciated!!!
Rob