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 am a new user and I have started a workflow but I am looking for any tips on how to achieve the desired result with a minimum size file output.
In brief, I have 3 Excel files (Business Plan, Mapping File and Template).
I would like to populate the Template with the monthly financial values in the Business Plan.
My initial idea was to join the Business Plan and the Mapping file by the 2 identifiers, Measure and Site, to get the columns that are used as in the Template and then populate the months columns (Jan 2020, Feb 2020 etc) of the Template.