This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
After using the Cross Tab Tool, I need a way to rename some of the column headers, but the quirk here is that I will have new columns each month that I am hoping I can automatically have renamed (don't want to have to maintenance the process each month).
Here is my process:
Here is a sample of the Summarization that is then transposed So the 'ParmMon' becomes the header:
I would like a way to rename the "0", "1", etc. to "SharesM0", SharesM2", etc., and then for next month when month 7 is now added, I will need it to automatically update the "7" to "shares M7" and so on for each month.