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