The directed movement of molybdate (MoO4 2-) ions into, out of or within a cell, or between cells, by means of some agent such as a transporter or pore. Molybdate is the bivalent anion derived from molybdic acid.