def fix_spaces_in_column_names(columns):
    """Returns the cleaned-up column names without spaces and in upper-case."""

    new_names = []
    for col in columns:
        new_name = col.strip()
        new_name = "".join(new_name.split())
        new_name = new_name.replace(".", "")
        new_name = new_name.upper()
        new_names.append(new_name)
    return new_names