First, I am using excel 2003.


I have data that is in a "flat" format meaning that data is like:
NAME MAILING SHIPPING
name1 address1-a Address2-b
name2 address1-c Address2-d
name3 address1-e address2-f

There may be duplicates of name and address1 such as:
NAME MAILING SHIPPING
name1 address1-a Address2-b
name2 address1-c Address2-d
name2 address1-c address2-f
name3 address1-g address2-h

What I need to do is get data from the previous example into the following
format while I need to know if the address is from mailing address or
billing address
NAME ADDRESS TYPE
name1 address1-a MAILING
name1 Address2-b SHIPPING
name2 address1-c MAILING
name2 Address2-d SHIPPING
name2 address2-f SHIPPING
name3 address1-g MAILING
name3 Address2-h SHIPPING


I am looking for how I would do this.... How should the logic be, or some
samples of how to break this dow. (this is far simplified of my actual
data, but shows what I need to do (i hope!))


Thanks
Bruce