Dynamically Change Column Displayed name

Hi   I have a table in SQL that get's refreshed at the start of every month which has the following columns    CustomerID - R6 - R5 - R4 - R3 - R2 - R1  R1-6 represent their spend classification...