Combine multiple lines

[dandy]

I am exporting from a database and I have to link a couple libraries together in order to get all the information pulled. However, when i export into Excel there are a bunch of duplicate lines (see below).

In column "DS0NCT" i do not want there to be duplicate values but i also need all the information from column "DT0NOT" to be in on cell and not multiple cells (i.e. Column "DS0NCT" there should only be one "000000002" but in column "DT0NOT" it should read "VOID - DO NOT USE. NCR WRITTEN IN ERROR - DAN DOUGLASS 10/17/17" all in one cell.

Thanks for any help. Please let me know if you need additional information.

 

[Joe4]

Your image attempt failed. There are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.