Report all product serial #s from multiple fields

I want to print a report of all equipment serial #s for a product we have. The unusual part of this is that the serial #s are in eight different fields within the same record because they're "mapped" ...