Iterative or Batch Macro

[knnwndlm]

Hello SME,

I have two sets of input: one the sample data and the other schema telling me the factor to add to the sample and how many times to do so. For example, if I have a factor of 100,000 with a multiple of 4, then I want my output to show the original amount plus 100,000 each time for 4 times.

I'm not sure whether to build an iterative or batch macro to do this. Could you please help?  Attached is an Excel file showing the input and expected output.

Thanks,

kwl 

[binu_acs]

@knnwndlm one way of doing this with the append tool

[knnwndlm]

Thanks @binu_acs!  If I were to do this in a macro, which macro should I use?  I'm looking for opportunities to hone my skillset in macro.

[Qiu · Accepted solution]

@knnwndlm 
I think both Iterative and Batch Macro can be applied for your case.
Batch Macro basically output data vertically so finally we need a Cross Tab to convert them to horizontal.

Iterative macro basically updates the the same data, and in your case, make data grows horizontally.

[knnwndlm]

Thank you much @Qiu !!