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.
As with most things in Alteryx, there's a few ways to accomplish what you are trying to do. Here are some solutions I came up with:
The first option is to use the multi-row formula to create a flag for rows where column 2 is the same as the next row column 2, use that flag to generate new rows where needed, then use another multi-row formula to change the new row values to Feb 2018.
The second example shows this same thing using date formulas for more flexibility.
The third example creates a dummy field to allow for a cross tab. From there you can just add a new column using a formula and transpose the "date" columns back to add the new row.