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.
I would suggest trying the Transform > Transpose tool. Select the Year_ fields as the data columns and everything else as Key columns. This will put the 'Year_' column headers in a new field ('Name') and the data in a new column ('Value').
Your formula could then be some thing like:
if [Data Availability] = "N/A" then Null() elseif [Data Availability]= [Name] then Pow([Year_T]/[Value],(1/[Market Growth CAGR Period (years)]))-1 else 0 endif
You could then use the Crosstab tool to restore the Year_ rows to columns. You might then need to filter unneeded rows or summarize the new Company CAGR field.