3 rows 1 column of data

[hjinsagency]

Hi Everyone,

I own an insurance agency, I was foolish enough to listen to a Lead Management service on using there dialer system last year. With it came 5000 policy x-dates a month (for 3 months) to contact and see if we can offer an insurance quote. Well the system was not a 1 man operation system to use.

So here is my problem...I have all these leads, the format on how they downloaded into excel is as follows if they have more than 1 vehicle:

FIRST NAME LAST NAME PHONE NUMBER ADDRESS CITY STATE ZIP.......NUMBER OF VEHICLES MAKE MODEL VIN YEAR
VEHICLES MAKE MODEL VIN YEAR
VEHICLES MAKE MODEL VIN YEAR

I have been cutting and pasting the additional vehicles into the same row but I have over 8000 left to do. I have already created additional headers V2 V3 V4.

Is there a way to move the extra vehicles to the same row as the rest of the data?

I already have a customized CRM so I can import the data but I can't get the data to import with the current format...please help...!

[arshad.99.ali]

Hi,

Please attach a sample file with expected result, so that it will give clear understanding of your requirement

[Special-K]

...and remember to either delete or change any sensitive data.

[FDibbins]

WQelcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )