It would be helpful to get a visual representation of what you data looks like, and what you want it to look like afterwards.
While you cannot upload files to this site, 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.
[TABLE="width: 636"]
<colgroup><col width="73" style="width:55pt"> <col width="71" style="width:53pt"> <col width="69" style="width:52pt"> <col width="125" style="width:94pt"> <col width="77" style="width:58pt"> <col width="64" style="width:48pt" span="2"> <col width="93" style="width:70pt"> </colgroup><tbody>[TR]
[TD="width: 73, align: left"]ID Number[/TD]
[TD="width: 71, align: left"]First Name[/TD]
[TD="width: 69, align: left"]Last Name[/TD]
[TD="width: 125, align: left"]Address[/TD]
[TD="width: 77, align: left"]City[/TD]
[TD="width: 64, align: left"]Zip[/TD]
[TD="width: 64, align: left"]State[/TD]
[TD="width: 93, align: left"]Items Number[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: left"]Nicole[/TD]
[TD="align: left"]Thomas[/TD]
[TD="align: left"]123 Now Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]95811[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: left"]Nicole[/TD]
[TD="align: left"]Thomas[/TD]
[TD="align: left"]123 Now Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]99213[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: left"]Nicole[/TD]
[TD="align: left"]Thomas[/TD]
[TD="align: left"]123 Now Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]99213[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: left"]Nicole[/TD]
[TD="align: left"]Thomas[/TD]
[TD="align: left"]123 Now Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]99212[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: left"]Tim[/TD]
[TD="align: left"]Smith[/TD]
[TD="align: left"]456 Reading Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]99213[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: left"]Tim[/TD]
[TD="align: left"]Smith[/TD]
[TD="align: left"]456 Reading Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]95810[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: left"]Tim[/TD]
[TD="align: left"]Smith[/TD]
[TD="align: left"]456 Reading Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]99212[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: left"]Chris[/TD]
[TD="align: left"]Austin[/TD]
[TD="align: left"]897 Past Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]95811[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: left"]Chris[/TD]
[TD="align: left"]Austin[/TD]
[TD="align: left"]897 Past Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]95800[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: left"]Chris[/TD]
[TD="align: left"]Austin[/TD]
[TD="align: left"]897 Past Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]99213[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: left"]Chris[/TD]
[TD="align: left"]Austin[/TD]
[TD="align: left"]897 Past Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]95811[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: left"]Mary[/TD]
[TD="align: left"]Turner[/TD]
[TD="align: left"]4785 Big Hollow Ln.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]95810[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: left"]Mary[/TD]
[TD="align: left"]Turner[/TD]
[TD="align: left"]4785 Big Hollow Ln.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]99204[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: left"]Mary[/TD]
[TD="align: left"]Turner[/TD]
[TD="align: left"]4785 Big Hollow Ln.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]95810[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: left"]Donna[/TD]
[TD="align: left"]Matthew[/TD]
[TD="align: left"]5623 Tinker Bell Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]99203[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: left"]Donna[/TD]
[TD="align: left"]Matthew[/TD]
[TD="align: left"]5623 Tinker Bell Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]95810[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: left"]Donna[/TD]
[TD="align: left"]Matthew[/TD]
[TD="align: left"]5623 Tinker Bell Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]99213[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: left"]Donna[/TD]
[TD="align: left"]Matthew[/TD]
[TD="align: left"]5623 Tinker Bell Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]95810[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: left"]Donna[/TD]
[TD="align: left"]Matthew[/TD]
[TD="align: left"]5623 Tinker Bell Rd.[/TD]
[TD="align: left"]Jacksonville[/TD]
[TD="align: right"]32286[/TD]
[TD="align: left"]FL[/TD]
[TD="align: right"]95810[/TD]
[/TR]
</tbody>[/TABLE]