Rename columns with weekday dynamic

Anonymous Well, if they are going to change all the time, then I would not promote them as headers and work with the default Column1, Column2, Column3, etc. for starters. Then, yes, you should be able to rename the columns based upon the current date and the number of the column. Alternatively, you again don't promote headers and unpivot them and then do find and replace essentially.