I have the need to import thousands of contacts from internet lists.  The lists are usually vertical instead of horizontal.  In other words, when I copy and paste into Excel, all the data goes into column A.  I need for the name to be in column A, the phone # in column B, etc.  I'm sure there is a way to pivot the data around and have tried using pivot tables but no luck so far.  Currently, I am having to cut and paste the data into the columns I need so it imports into SalesForce.  Anybody solved this issue before?

I have the need to import thousands of contacts from internet lists.  The lists are usually vertical instead of horizontal.  In other words, when I copy and paste into Excel, all the data goes into column A.  I need for the name to be in column A, the phone # in column B, etc.  I'm sure there is a way to pivot the data around and have tried using pivot tables but no luck so far.  Currently, I am having to cut and paste the data into the columns I need so it imports into SalesForce.  Anybody solved this issue before?

I have the need to import thousands of contacts from internet lists.  The lists are usually vertical instead of horizontal.  In other words, when I copy and paste into Excel, all the data goes into column A.  I need for the name to be in column A, the phone # in column B, etc.  I'm sure there is a way to pivot the data around and have tried using pivot tables but no luck so far.  Currently, I am having to cut and paste the data into the columns I need so it imports into SalesForce.  Anybody solved this issue before?

I have the need to import thousands of contacts from internet lists.  The lists are usually vertical instead of horizontal.  In other words, when I copy and paste into Excel, all the data goes into column A.  I need for the name to be in column A, the phone # in column B, etc.  I'm sure there is a way to pivot the data around and have tried using pivot tables but no luck so far.  Currently, I am having to cut and paste the data into the columns I need so it imports into SalesForce.  Anybody solved this issue before?