Using excel

1) Install the following add-on into excel:
http://www.asap-utilities.com/

2) Then transpose the rows into columns (every 6 lines will be one row/record).

3) delete the 6th column

4) Use the CONCATENATE function to join the columns.

5) Ask questions when you get stuck.

Additional links:

http://www.poi-factory.com/node/10065
http://www.poi-factory.com/node/11946

There is an Excel Add-on located at asaputilities.com that will help you with many Excel tasks. Ont called advanced transposer takes a series of items in a column that is repeated such as 1,2,3,4,5 repeat 1,2,2,3,4,5 and puts all ones in one column 2 in one column etc. then delete the unwanted column. It will then merge two or all columns with spaces punctuation or characters. It has over 300 macros too many to mention here but makes creating POIs easier and quicker.

Thanks

DRMCMTR posted after you posted, but he was the first reply. Weird.

FYI, I posted first and then re-edited my post with additional info/corrections.

First question of many.

How do you do this step?

Under columns and rows...

1) block the range that you want converted (not the entire column A)

2) ASAP/Format/Advance transposer

Thanks I found it now and now I will finish the USA Hyundai Poi by Saturday.

There used to be an 'official' Hyundai Dealer Database at:
http://www8.garmin.com/support/agree.jsp?id=3303

Unfortunately, when you click "I agree" it now takes you to the generic download page.

They might have made this a WebUpdater-only download, in which case, we would need to know the identifier, for the Hyundai/Garmin Nüvi 360.

(Despite all the dire warnings about only loading it on a Nüvi 360, this was in fact a MAP - a map containing embedded POIs, but no roads. The Volvo version is still available).

Can this macro make a forced Line Break?

If it can't do that then my poi is done. I don't have to the time to manually Line Break every entry (749 of them). I will upload it tonight.

Be careful with line breaks...they are different between models.

If you want a line break (ALT-ENTER) then add the following code &char(10)&

(EX) =C1&char(10)&D1

I think the Garmin 350/360 requires an < BR >
so change the concatenation according.

For the poi's that I made that only have around 50 or so I make line breaks manually by using Alt+Enter. It shows up fine in my 350. So I guess the finished file will not have line breaks in the address. I just uploaded the Hyundai file a couple minutes ago, so expect to see it by tomorrow.

FYI, I create my files with the formula version char(10) and then upload that version.

The line breaks can easily be changed with a mass update (find/replace).

As was reported by 1weird1 in http://www.poi-factory.com/node/14627 , you can make your life much easier by using GeePeeEx Editor. I realize that some people love the challenge of making fine furniture with a pocket knife.

Select columns you wish to join (merge). Select ASAP>Columns and Rows> Merge Columns. Enter {lf} in field Check preview then GO or enter. The columns will be merged with the entry of each column on a separate line. You can substitute ", Space" no quotes and each column entry will be separated by a coma and space. Speeds up combining items into comment field.

Thanks, Now I got everything with line breaks. Now, when It is on the site I'll just update it.

Thanks... I did not know this (still learning the tool).

FYI, it will flag duplicates under ASAP>information>Count dups...

You can color duplicates then sort by color an delete all duplicates at one time. Really a time saver. I did not know about flagging duplicates which is better than deleting them using Excel to do it. Thanks.

Thanks for the awesome tip! Just tried it and had some duplicates on some of the poi files I made.

I finally got around to downloading the ASAP add on for Excel.Glad I read the post.This program does elimated a lot of work.I just tried flagging some duplicates and was really surprised with the results.