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" to another piece of equipment (a separate bioreactor for each piece of equipment), which is how we need the entire record to be displayed.

So, I want to print a report that lists all serial numbers and the company they're associated with, for example:

235777     ABC Company           Macon, Georgia
235778     DEF Company           New York, New York
235779     GeeWhiz Company   San Francisco, CA
235780     XYZ Company           Seattle, WA

I created a field called "All Serial #s" and below is what I've got in the Formula - Text field. It works "sort of" in that I don't get an error message (!). However, it doesn't appear that it getting all of the serial #s. Any initial thoughts of what I might be doing wrong?

If(

Trim([Serial #1])<>"", ToText([Serial #1]),
Trim([Serial #2])<>"", ToText([Serial #2]),
Trim([Serial #3])<>"", ToText([Serial #3]),
Trim([Serial #4])<>"", ToText([Serial #4]),
Trim([Serial #5])<>"", ToText([Serial #5]),
Trim([Serial #6])<>"", ToText([Serial #6]),
Trim([Serial #7])<>"", ToText([Serial #7]),
Trim([Serial #8])<>"", ToText([Serial #8]))