Hello all,
I'm handling a large quantity of data with names, titles and emails I have to upload into a CRM.
Problem is my sheets have multiple columns with contact infos (Names, Titles, email) for 10 sometimes 15 people in one row but different columns.
Our CRM system cannont accept such a input as one row is considered as a lead record.
That is, if I upload the data as is now, I will only able to get the first Names, Title and email columns.
Screenshot 2020-02-13 at 12.35.55.png
I've actually been working on LibreOffice for this operation. LibreOffice does not seem to have any solution for this specific problem challange.
I'm now turning up here to know if Excel perhaps would have a concrete solution. Something which would allow to split the columns and add rows bellow to create new rows with those contacts.
I know there is a Transpose Function but that's not what I'm looking for because the Transpose is good to handle a small amount of data and easely put it vertically or horizontaly.
Any concrete suggestions ?
Bookmarks