I am trying to create a loop in excel with formulas only. What I am trying to achieve is described below. Let's say I have 3 columns as inputs: (i) Country; (ii) variable; and (iii) year. I want to expand from these inputs to then assign values to these parameters.
Inputs:
Country Variable Year
GB GDP 2015
DE area 2016
Outputs:
Country Variable Year
GB GDP 2015
GB GDP 2016
GB area 2015
GB area 2016
DE GDP 2015
DE GDP 2016
DE area 2015
DE area 2016
How can I do that efficiently using Excel?
Many thanks