Excel formula

Question

Hi team,

i have the attached the Alteryx result.

ProdUnit24-Apr24-May24-Jun24-Jul24-Aug24-Sep24-Oct24-Nov24-Dec25-Jan25-Feb25-MarQ125Q225Q325Q425Clinker ProdKMT 218162255264246260257257226203245271(Apr24+May24+Jun24)(Jul24+Aug24+Sep24)(Oct24+Nov24+Dec24)(Jan25+Feb25+Mar25)

How i can get the Q125 to Q425 values in  the same row of the clinker prod at the end of the clinker row. i had also attached the desired result. because in excel the formula are implemented at the cell level so the Quarter calculation should not impact the below rows. I have to implement some other formula for other rows which are different for other each row.

Please let me know if you have any questions.

Best Regards,

Kaustubh

Alteryx Q1.png

Result 1.png

Raj · Answer

@Kaustubh17 
find the worflow attached
mark done if solved.

2130.yxmd

Kaustubh17 · Answer

@atcodedog05 its changing right now is 25 later that will be 26 and so on that's why i transpose the data, so that in future the column will not increase only the rows will increase.

atcodedog05 · Answer

Does the month columns keep changing or is it static?