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 need to read the Opening Year for a store and then set the Opening Year Population equal to the column that contains that year's population. I've attached a simple spreadsheet example to illustrate what I'm talking about
Before reading the description, I thought my reply would include mention of the Dynamic Select tool. However, since you need a different column per record, my suggestion involves transposing the data first.
I've attached an example of how I would go about this problem. Another option would be to look into the Dynamic Formula tool available from the CReW tools.