I am using Office 360 (Excel) and I have a csv file with the following headers (and corresponding data):
First Name,Last Name,Address,City,State,ZIP,Phone,Home Owner,Source
The printing company I am using requires the following headers:
Record Id,Salutation,First Name,Middle Name,Last Name,Name Suffix,Title,Business,Address 1,Address 2,City,State,Zip
I can of course make sure the fields I am using from the first header match the second, but how do I merge the csv file into the file with the proper headers and be sure the data populates the correct column?
Thanks for any (easy ways to tackle this.
Ljay
First Name,Last Name,Address,City,State,ZIP,Phone,Home Owner,Source
The printing company I am using requires the following headers:
Record Id,Salutation,First Name,Middle Name,Last Name,Name Suffix,Title,Business,Address 1,Address 2,City,State,Zip
I can of course make sure the fields I am using from the first header match the second, but how do I merge the csv file into the file with the proper headers and be sure the data populates the correct column?
Thanks for any (easy ways to tackle this.
Ljay